This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Customer 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'?
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
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 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 ?
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).
Ah, I understand now. I have applied that rule to the background and foreground colours to make them white if the dimensionality is 1
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 😀