Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
somenathroy
Contributor III

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
MVP & Luminary
MVP & Luminary

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

View solution in original post

2 Replies
MVP & Luminary
MVP & Luminary

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

View solution in original post

somenathroy
Contributor III

Re: getcurrentselections / getselectedcount not working with non adding dimentions

Thanks a lot. It is working now.