Discussion board where members can get started with Qlik Sense.
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,
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.
View solution in original post
Thanks a lot. It is working now.