topic Pivot Table Adjustments in QlikView

Pivot Table Adjustments

priyarane — Thu, 19 Mar 2015 11:39:16 GMT

Hi Experts,

Here is the sample Application,

I am looking for Total should come only once and Department data should come at top now its coming at bottom. Please check after exporting to Excel.

its in indent mode, i need that also.

Thu, 19 Mar 2015 11:49:39 GMT

hi,

you have used multiple if condition so that in your expression (not showing option to tick partial sum).

If you change it in sum (if condition) then it will visible.

or select Straight table.

priyarane — Thu, 19 Mar 2015 13:08:25 GMT

Hi Vimlesh,

Its in Indent mode, thats why its not visible.