Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Chart Layout

Hi Guys,

I am working with 3 fields, ID, DATE and A COUNT DIMENSION.

ID and Date are both dimensions as IDs have multiple dates.

The Dimension is a count of another field.

Is there anyway to set the table up on QLIK so it would look like below? (Similar to how you can work with a pivot table on excel

   

  DATE1DATE2DATE3DATE4
ID 1XXXX
ID 2XXXX
ID 3XXXX
ID 4XXXX

With X being the returned Count Expression values.

Currently the chart looks like this:

   

DATEIDCOUNT
DATE1ID1X
DATE2ID2X
DATE3ID3X
DATE4ID4X

I've tried the horizontal function on the presentation tab but this is not the answer.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi Tim,

Select pivot table under charts

Print 1.png

then click and drag the column name to the side until you see the arrow as below

Print 2.png

Hope it helps,

Fernando

View solution in original post

5 Replies
krishnacbe
Partner - Specialist III
Partner - Specialist III

Hi,

Create a Pivot Table and move the Date column to Horizontal Tab heading.

sunny_talwar

May be use Pivot table here and pivot the Date dimension:

QlikView | Pivot Tables - YouTube

krishnacbe
Partner - Specialist III
Partner - Specialist III

Please refer the attached qvw.

Anonymous
Not applicable
Author

Hi Tim,

Select pivot table under charts

Print 1.png

then click and drag the column name to the side until you see the arrow as below

Print 2.png

Hope it helps,

Fernando

Anonymous
Not applicable
Author

Perfect - Thank you