Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
srinivasuluraju
Contributor
Contributor

In Pivot Table how to display like as below

Hi All,

I need your help,how to create pivot table in Qlik sense like as below.i want to display ' May 18' as main category,under this have to display  subs,% ,Cv as Sub Category and calculated subs ,%,Cv values.

Pivot  Table.PNG

Thanks in advance!

 

4 Replies
shiveshsingh
Master
Master

You should use the month year column as dimension(which is showing May18), and then drag it to upper row.

And use these as expressions - subs,% ,Cv .

You'll get the desired output.

srinivasuluraju
Contributor
Contributor
Author

 Thanks for your quick response.That is working well,but i want to display Above arrow value as separate Column like as image.

shiveshsingh
Master
Master

which one is the arrow value?

srinivasuluraju
Contributor
Contributor
Author

That one calculated value like(Sum(Sales)).On Right hand edge Symbol in that image.