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
Partner
Partner

How can i make a dynamic variable

I want to make a variable that can count the number of times any of my  filter gets selected.

For example if I select a value in a filter a number of times. I want to calculate the sum of total number of selection.

Should we use a for loop to achieve this . If yes how ?

17 Replies
devarasu07
Honored Contributor II

Re: How can i make a dynamic variable

Hi,

Can you share mock data and expected output in excel format. tks

Partner
Partner

Re: How can i make a dynamic variable

filter_snip.JPG

So in my report date filter everytime getselectedcount(reportdate) =1, I want to calculate the number of times this condition gets fulfilled.

Partner
Partner

Re: How can i make a dynamic variable

PFA of the demo app.

Partner
Partner

Re: How can i make a dynamic variable

I know that in QlikView you could take out memory statistics that gave you somewhat info like this. How many times an object has been used,  but I have no idea if this could be done in QlikSense.

There is also the applications that follows with an installation of Qlik Sense that shows usage of applications. There might be something in those that could point you in the right direction.

Partner
Partner

Re: How can i make a dynamic variable

stalwar1‌ please help

Partner
Partner

Re: How can i make a dynamic variable

shraddha.g‌ need your help

Re: How can i make a dynamic variable

I have never done this before and not even sure if this can be done or not. But just so I can understand this completely, does this functionality survive the reload/sessions or is this per reload/session. Meaning if I start the app today, would it start from my last selection last time or will it restart from 1?

Partner
Partner

Re: How can i make a dynamic variable

no it should restart while starting a new session. Whenever I open a new app the counter value should be 1

Re: How can i make a dynamic variable

Have you used Triggers in Qlik Sense, I think that is what you will need. I have not used triggers in Qlik Sense, but if it help I can try to create a qvw sample (not sure if you are able to open that or not)