topic Re: Qlik sense Pivot table in App Development

Qlik sense Pivot table

Fri, 04 Nov 2016 03:21:54 GMT

Is it possible to get Grand total and Sub total at the bottom of dimensions in Pivot table chart in Qlik sense? Also how can i color few columns?

In above image, How to get Sub total of "Threat Protection" at bottom and Grand total at very bottom as we get in Excel pivot table.

Also, Is it possible to color Commit, Best case and Pipeline in Blue and others in Green color? swuehl stalwar1 gwassenaar

shraddha_g — Fri, 04 Nov 2016 06:48:23 GMT

It is not possible to change position of Total.

For Colors,

go to Measures, for each measure there is Background color property available. add color or rgb value there for each measure

Fri, 04 Nov 2016 06:59:16 GMT

How to add RGB value in expression?

shraddha_g — Mon, 07 Nov 2016 07:11:12 GMT

ex - rgb(200,0,0)

Mon, 07 Nov 2016 07:15:48 GMT

Got it Thnx.