Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
priyarane
Specialist
Specialist

Pivot Table Adjustments

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.

2 Replies
Not applicable

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
Specialist
Specialist
Author

Hi Vimlesh,

Its in Indent mode, thats why its not visible.