Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
somenathroy
Not applicable

getcurrentselections / getselectedcount not working with non adding dimentions

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Not applicable

Re: getcurrentselections / getselectedcount not working with non adding dimentions

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.


talk is cheap, supply exceeds demand
2 Replies
Gysbert_Wassenaar
Not applicable

Re: getcurrentselections / getselectedcount not working with non adding dimentions

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.


talk is cheap, supply exceeds demand
somenathroy
Not applicable

Re: getcurrentselections / getselectedcount not working with non adding dimentions

Thanks a lot. It is working now.