topic Re: In Pivot Table how to display like as below in App Development

In Pivot Table how to display like as below

srinivasuluraju — Thu, 20 Jun 2019 06:41:37 GMT

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!

Re: In Pivot Table how to display like as below

shiveshsingh — Thu, 20 Jun 2019 06:54:17 GMT

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.

Re: In Pivot Table how to display like as below

srinivasuluraju — Thu, 20 Jun 2019 10:44:15 GMT

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

Re: In Pivot Table how to display like as below

shiveshsingh — Thu, 20 Jun 2019 10:58:07 GMT

which one is the arrow value?

Re: In Pivot Table how to display like as below

srinivasuluraju — Thu, 20 Jun 2019 11:04:59 GMT

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