Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table : only one expression split by a dimension column

Dear all,

I need to present a pivot table as followed :

                      Expression1 Expression2

Dimension1.                       totalExpr2   Jan.     Feb.    Mar.   Apr.   May. ..... Dec

Total               30.                70.              10.       2.        3.       5.      0.            0. 

value1.           10.                20.              5. .       2.        3.       5.      0.            0. 

value1.           10.                30.              10.       2.        3.       5.      0.            0. 

value1.           10.                20.              20.       2.        6.       5.      0.            0. 


To sum up : the expression2 must be splitted by month (my dimension2) but not the expression1


Thank you in advance for your help.


Regards


Pascal


0 Replies