How to make a expression treat as a dimension ?

[suvechha_b]

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

[suvechha_b]

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

[Anil_Babu_Samineni]

May be use this as Master dimension

Aggr(Count({$<[UW_MONTH_KEY] = {"$(=$(vMaxUWMonth))"}>} Distinct [Policy Number]), Partner)