Dynamic Dimension

[sanjujeeboy]

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

[kaushiknsolanki]

Try this expression.

Sum({<Category= {"A"}>+<Category= {"$(=If(Getselectedcount(Category)=0,'B',Maxstring(Category)))"}> }Sales)

[sanjujeeboy]

i need this in calculated dimensions. can you help in this?