Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm new to qliksense. I have dimension "X" on my pivot table. And I'd like to filter my dimension in measure set expression but show the outcome in all rows.
NOTE: XYZ is a variable.
I try (SUM({<A= {'XYZ'}>} CARDS) or (SUM({$<A= {'XYZ'}>} CARDS) but pivot rows are filtered only for row A.
Assume that (SUM({<A= {'XYZ'}>} CARDS) = 10, I want table like this;
A 10
B 10
C 10
but I get;
A 10
Thanks for help.