Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
MVP & Luminary
MVP & Luminary

Re: Data Presentation in Pivot Chart

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
Highlighted
Creator
Creator

Re: Data Presentation in Pivot Chart

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