Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
sbfernandes
Contributor III
Contributor III

Chart straight table: referencing the value of the dimension in expression

Greetings.

I have a dimension D_CODE which has multiple values like Z1, Z2, Z3, Z4

My expression is 

count({<UID={"=alt(aggr(sum({<D_CODE-={D_CODE}>}D_MIN), UID),0)<=15"}>}distinct UID)

is there a way to reference the value of D_CODE in the expression, so that the expression is now:

D_CODE Expr
Z1 count({<UID={"=alt(aggr(sum({<D_CODE-={'Z1'}>}D_MIN), UID),0)<=15"}>}distinct UID)
Z2 count({<UID={"=alt(aggr(sum({<D_CODE-={'Z2'}>}D_MIN), UID),0)<=15"}>}distinct UID)
Z3 count({<UID={"=alt(aggr(sum({<D_CODE-={'Z3'}>}D_MIN), UID),0)<=15"}>}distinct UID)
Z4 count({<UID={"=alt(aggr(sum({<D_CODE-={'Z4'}>}D_MIN), UID),0)<=15"}>}distinct UID)
Labels (1)
0 Replies