Qlik Community

New to Qlik Sense

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

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
clarcombe
Contributor III
Contributor III

Create a total for second measure only

Customer only wants totals on Second 'Solde' columnCustomer only wants totals on Second 'Solde' columnI have currently enabled totals on second dimension 'Tache'. Is it possible only to have a total on the second 'Solde' column but not on 'Obj'? 

Labels (2)
1 Solution

Accepted Solutions
stevejoyce
Specialist II
Specialist II

You can use dimensionality() to control.  Add it as expression to see how it applies to your table structure.

 

In your example your 2nd column total should dimensionality() = 1.

So in your 1st expression you can do If(Dimensionality() <>1, yourexpression)

View solution in original post

4 Replies
stevejoyce
Specialist II
Specialist II

You can use dimensionality() to control.  Add it as expression to see how it applies to your table structure.

 

In your example your 2nd column total should dimensionality() = 1.

So in your 1st expression you can do If(Dimensionality() <>1, yourexpression)

clarcombe
Contributor III
Contributor III
Author

Thanks for the reply Steve. I'm not really sure how that helps though. The rule I have to apply applies to the measure and not the dimension.The OBJ column is the TimeLimit MeasureThe OBJ column is the TimeLimit Measure

So I was thinking of putting something in the text column colour to say that if its the total being displayed then set it to Yellow so that it would appear hidden. Is this even possible ?

stevejoyce
Specialist II
Specialist II

Did you try Dimensionality() .  Dimensionality returns the dimension level.  You can use this to set a condition specific for the Total row.  For your Obj measure If(Dimensionality() <>1, yourexpression).

clarcombe
Contributor III
Contributor III
Author

Ah, I understand now. I have applied that rule to the background and foreground colours to make them white if the dimensionality is 1

Background Colour=If(Dimensionality()=1,White(),$(vBackgroundColour))

Text Colour ==If(Dimensionality()=1,White())

It feels like a bit of a cheat to hide numbers but it works.

I'm open to a more professional solution using Dimensionality if you have one 😀