Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
How can I make a expression to a dimension in Qliksense pivot table.
My Expression is - Count({$<[UW_MONTH_KEY] = {"$(=$(vMaxUWMonth))"}>} Distinct [Policy Number])
I tried to make the expression as Master dimension , but it is saying invalid dimension. How I treat this expression as dimension.
See below image - The Pivot table should show once the partner as Nimbis - Dynamic Thinking and the Policy Count as - 4037 then all the rest expression as it is.
Regards,Suvechha
May be use this as Master dimension
Aggr(Count({$<[UW_MONTH_KEY] = {"$(=$(vMaxUWMonth))"}>} Distinct [Policy Number]), Partner)