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: 
l26b
Contributor III
Contributor III

Conditional totals on pivot table

Hi, 

 

I want to create a pivot table with 3 dimensions on Row, one on column and I want to show Totals for the dimension on column but I want to show Totals only when there are multiple weeks selected. default view is a bookmark with current week selected so that is one week and for that case I do not want to Show Totals. 

 

I also have 3 metrics, so it will show totals per 3 metrics but otherwise I want those 3 metrics permanentely calculated

 

 

thank you 

 

 
Labels (3)
1 Reply
morgankejerhag
Partner - Creator III
Partner - Creator III

You can add the Week dimension twice to columns - one with Totals and one without. Then add "Show column if" as count(distinct Week)=1 on the Week-column without total and count(distinct Week)>1 on the other.