Support Portal ContactGet in touch

How to flip a Qlikview Chart Table

   Words by CRM Consultancy

   on 15/04/2016 08:00:00

Qlikview allows us to add Chart Tables to our Dashboard to plot data or aggregated data over groups – and these groups can often represent groupings by date for Day, Week or Month.

By default our Chart Table will present each Dimension as a New Row, with the Expressions as additional Columns:

image

This format can be fine for certain types of Table Charts, however when we are working with Date Groupings we often want these Groupings to stretch out across the Dashboard – so we have N number of Columns and a Fixed Number of Rows.

To implement this in our Dashboard, we can access the Properties of the Chart, and then the Presentation Tab, to find the Checkbox for ‘Hortizontal’.

image

Ticking this Checkbox will then ‘flip’ the Chart and set our Dimension Groupings as new Columns, and our List of Expressions as a fixed number of Rows running down.

image

This can be useful for handling a variable number of Groups as allows the Dashboard User to read from Left to Right for the data within this Table rather than scrolling down. (particularly when plotting Dates over Time)

As this mimics the normal reading pattern, this typically gives us a better dashboard.

Quick Qlikview Tips

Share this Article

Search Articles

Filter Articles

CRM Tech DocMan

Recent Articles

CRMCS Quick Start Guide: How To Produce a Microsoft Teams Live Event Dynamics 365 Marketing: Lead Scoring and Sales Acceptance Designing and Developing Microsoft Power Apps Portals Thank You for Attending CRMCS’ Webinar - Achieving B2B sales excellence with Dynamics 365 & Microsoft Teams Thank You for Attending Our Webinar - Achieving B2B sales excellence with Dynamics 365 & Microsoft Teams Webinar: Discover How CRMCS Have United Dynamics 365, SharePoint and Microsoft Teams To Create Sales Excellence Ignite your workflow by adding DocDrive365 to Office 365 The CRMCS guide to everything you need to know about integrating Teams with Dynamics 365 Saving Time By Keeping Documents In One Place TDE Database Encryption with On Premise Dynamics The Key to Successful Compliance in 2020 Part 2: Let’s get GDPR Compliant with Microsoft Power Automate Top 3 Essential Tips for Remote Working Dynamics 365 Marketing: Top 5 Best Features Dynamics Day in the Life - Puma Investments Can you use Teams to amplify collaboration in Dynamics? Part 1: Using a Scheduled Power Automate to Trigger Expiry Date Reminders The secrets of successful document collaboration in Dynamics CRMCS launches new AppSource approved DocDrive365 Dynamics Day in the Life - Moneypenny Release Management Add the App to Dynamics DocDrive365 Security: Day One - Getting Started with Dynamics to SharePoint Permissions Building a New Scheduled Process using Flow
  • "Paul has made a real difference to how my team of 24 people record and store valuable customer data and sales opportunities. Highly recommended."

    James, Operations Director

  • "Understanding your business allows us to advise when to implement aspects of CRM and, likewise, when not to."

    Paul McQuillan, Managing Director

  • "Dynamics 365 and CRMCS have made a real lasting difference to our business, allowing us to replace older systems that were holding back our performance."

    Grahame, Chief Operating Officer

  • "James worked well with us to help connect CRM with Outlook and relate how this might benefit our team using CRM for Property Care."

    Natalie, Property Care Supervisor

  • "Matt was really good with helping us run User Testing on the new Compliance Module of our CRM System."

    Tom, Compliance Administrator

Prefer to go old-school?

Write to us using the below addresses.

Head Office
CRM Consultancy
61 Oxford Street
Manchester
M1 6EQ

London Office
CRM Consultancy London
Grosvenor Avenue
London

Content © CRM Consultancy.