Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Aho
Contributor
Contributor

Pivot Table - Only show Totals on multiple colum selection

Hi all

Is it possible to have a dynamic Totals colum in a pivot table?

In this example I have the sales for two companies and a Totals colum.

    Sales  
Product Totals Company A Company B
A 10 5 5
B 20 10 10
C 30 15 15

 

If I only select one company I don't want to show the Totals colum as I will have two colums with the same data.

  Sales
Product Company A
A 5
B 10
C 15

 

Thanks

Andreas

Labels (2)
1 Solution

Accepted Solutions
Aho
Contributor
Contributor
Author

Hi Marcus

Thanks! It works as intended with this expression:

 

  • If (count(distinct Company)=1 and secondarydimensionality()=0, 0, 1)

 

/Andreas

View solution in original post

2 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

You may try it with an extended expression, like:

if(count(distinct Company) = 1 and secondarydimensionality() = 0, null(), YourExpression)

- Marcus

Aho
Contributor
Contributor
Author

Hi Marcus

Thanks! It works as intended with this expression:

 

  • If (count(distinct Company)=1 and secondarydimensionality()=0, 0, 1)

 

/Andreas