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

Data Presentation in Pivot Chart

I have to show 2-QTR which will be the sum of 0,1,2 and 4-QTR which will be the sum of 0,1,2,3,4 fields and so on. I have got the calcs for this, but my question is how will I display it like the above format. Adding a new expression will not help because it will display the records as new row.

2 Replies
Gysbert_Wassenaar

Create a new table with a new dimension in the script:

LOAD * INLINE [

OldDim, NewDim

0,0

1,1

2,2

3,3

4,4

5,5

6,6

7,7

8,8

9,9

0, 2_QTR

1, 2_QTR

2, 2_QTR

0, 4_QTR

1,4_QTR

2,4_QTR

3,4_QTR

4,4_QTR

5.4_QTR

etc...

]

Then use NewDim as dimension in your pivot table instead of OldDim


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Hi,

Thanks for your reply. I think above solution will not work because 2-QTR,4-QTR,9-QTR are not straight sums. Somewhere these show averages and for some other metric these show sum and so on.

Moreover I am using ASOftable to get quarters