topic Re: Qlik Sense Stacked Bar chart Calculation Timed out in App Development

Qlik Sense Stacked Bar chart Calculation Timed out

Gowtham — Fri, 20 Dec 2019 06:36:26 GMT

Hi All,

I have created one stacked bar chart in qlik sense. It is working fine when the Date is selected but when there is no selection,the chart became calcluation timed out after sometime

Dimensions - Id and Source

Expression - if(GetSelectedCount(Period)=0,
Count({<DispenseDateKey_Monthname={'$(=$(vCurrMonth))'}>}Source),
Count({<DispenseDateKey = {">=$(=(min(Period)))<=$(=(max(Period)))"}>}Source)
)

Can anyone help me optimize the expression to fix this calculation timed out issue?

Re: Qlik Sense Stacked Bar chart Calculation Timed out

Anil_Babu_Samineni — Fri, 20 Dec 2019 07:39:05 GMT

How many aggregated rows are available for each object using this?

Count({<DispenseDateKey_Monthname={'$(=$(vCurrMonth))'}>}Source)

Re: Qlik Sense Stacked Bar chart Calculation Timed out

Gowtham — Fri, 20 Dec 2019 07:48:51 GMT

There are 237.4k aggregated rows for this expression

Thank you

Re: Qlik Sense Stacked Bar chart Calculation Timed out

Anil_Babu_Samineni — Fri, 20 Dec 2019 08:16:49 GMT

I feel always, set analysis is good option, But this way

Count(If(DispenseDateKey_Monthname='$(vCurrMonth)', Source))

Re: Qlik Sense Stacked Bar chart Calculation Timed out

Kushal_Chawda — Fri, 20 Dec 2019 10:00:06 GMT

what is the expression in vCurrMonth? How values in DispenseDateKey_Monthname looks like?