Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Gowtham
Contributor III
Contributor III

Qlik Sense Stacked Bar chart Calculation Timed out

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?

1 Solution

Accepted Solutions
Anil_Babu_Samineni

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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

4 Replies
Anil_Babu_Samineni

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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Gowtham
Contributor III
Contributor III
Author

There are 237.4k aggregated rows for this expression

Thank you

Anil_Babu_Samineni

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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Kushal_Chawda

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