topic Re: Optimize a calculated dimension in QlikView

Optimize a calculated dimension

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

Hello, I have a dimension containing a if but the response times are very long because volumes are important. Do you have solutions to optimize?
Thank you

Aggr(If(Rank(Sum([Ca Produit HT])) < 2, [Super Famille]), [Code Client],[Super Famille])

Re: Optimize a calculated dimension

vishsaggi — Thu, 29 Jun 2017 20:18:12 GMT

I have not tried but just check if this works?

= Aggr(Only({< [Super Famille] = {"= Rank(Sum([Ca Produit HT])) < 2 " } [Super Famille]), [Code Client],[Super Famille])

Re: Optimize a calculated dimension

sunny_talwar — Fri, 30 Jun 2017 02:42:26 GMT

May be don't use a calculated dimension, but use a set analysis in your expression.

Re: Optimize a calculated dimension

Anonymous — Fri, 30 Jun 2017 08:09:38 GMT

thanks

I tried to change by an expression like that but I have some bizarre cases in yellow.The function does not match with rank

if ( aggr(Max(total(turnover)),customer_code)>0,1,0)

Do you know why?

thanks for your help

Re: Optimize a calculated dimension

Anonymous — Fri, 30 Jun 2017 08:21:25 GMT

Application example

thanks

Re: Optimize a calculated dimension

passionate — Fri, 30 Jun 2017 08:41:03 GMT

If you want to show top 2 values why don't you try dimension limit.

Re: Optimize a calculated dimension

sunny_talwar — Fri, 30 Jun 2017 11:17:25 GMT

May be this?

Count(DISTINCT Aggr(If(Rank(Sum(turnover)) < 2, customer_code), customer_code, family))

Re: Optimize a calculated dimension

Anonymous — Fri, 30 Jun 2017 12:53:37 GMT

wonderful

thanks you very much for your help