Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Dimension

Guys,

For the below discussion, I got the solution by expression wise but I want to achieve the same by getting the values in a dimension by script wise.

Bar chart

Please help.

2 Replies
sunny_talwar

If I may ask, why do you need this from your dimension?

Anonymous
Not applicable
Author

Because using this expression in the front end, may cause slow performance. I mean it can load much more time to the selected value.

If I make it as a dimension in the script itself, it is pre-calculated and no loading issues will be there.

Please check the below expressions whether it will take long time to load,

Count({<Customer=E(Customer),WithProp_ID=P(WithProp_ID)>}FieldName)

sum(AGGR(if(Count(DISTINCT TOTAL <WithProp_ID> Customer)>1,1,0),Customer,WithProp_ID))