Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i have a DImension "Category" which has values A,B,C,D,E and Measure "Sales"
my requirement is that in the pivot table by default A & B should always show. When user selects C, then A & C should show
similary for D, A&D and for E , A&E
how to achieve this in qliksense?
Thanks
Try this expression.
Sum({<Category= {"A"}>+<Category= {"$(=If(Getselectedcount(Category)=0,'B',Maxstring(Category)))"}> }Sales)
i need this in calculated dimensions. can you help in this?