getcurrentselections / getselectedcount not working with non adding dimentions

[somenathroy]

Hi All,

In a Qlik Sense table, I have added 2 dimensions (Country and State) and sum(sales) columns. If I add a condition into the measure like,

if (GetSelectedCount(District)) >0, sum(Sales_district), Sum(Sales))

It is not working, calculation timed out.  Please note District field has not been added into that table.

Can anyone please share if any work around.

Thanks & Regards,

som

[Gysbert_Wassenaar · Accepted solution]

Perhaps this works:

if ($(=GetSelectedCount(District))) >0, sum(Sales_district), Sum(Sales))

If it doesn't then please post a small qlik sense apps that demonstrates the problem.

[somenathroy]

Thanks a lot. It is working now.