Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys,
i have a following example table:
Column A, Column B, Column C
London, X14, 0
Paris, C84, -1
Brüssel, K99,0
New York, E12, -1
Now i want that the table only show the columns where the Value in Column C has a -1.
Column A, Column B, Column C
Paris, C84, -1
New York, E12, -1
I tried the following formular under the column "Column A" ind the "Show column if section":
=Sum(Column C)<0 also
=Sum(NUM(Column C))
Unfortunately it didn´t work.
Thank you in advance!
For the Column A dimension try the expression:
=Aggr(Only({<[Column C]={'-1'}>}[Column A]),[Column A])
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com