Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks in advance!
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.
Thanks for your quick response.That is working well,but i want to display Above arrow value as separate Column like as image.
which one is the arrow value?
That one calculated value like(Sum(Sales)).On Right hand edge Symbol in that image.