topic Dimension in QlikView

Dimension

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Please help.

sunny_talwar — Mon, 31 Jul 2017 13:17:03 GMT

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

Anonymous — Mon, 31 Jul 2017 13:40:59 GMT

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))