Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
my requirement is to be able to use the number of values selected in a filter pane in a calculation in a table..
I have a filterpane which contains MonthNames - Jan 2023 - Dec 2023. This field is not included in the table in which I want to make my calculation.
Based on how many months the user selects I want to use the count in a calculation of demand. By default in my table the demand figure is annualised. If a user selects one month in the filter pane I want the demand figure to be 1\12th, if they select two months 2\12ths and so on.
I was hoping to be able to capture the count of selected periods in a variable and then use it in my calculation of demand. Something like this:
=Sum(Demand)/12 * vCountPeriods
Any suggestions would be appreciated..
Thanks
Hi @John117
Maybe you can use the GetSelectedCount Function
Like this:
GetSelectedCount(Period)
Then on your Formula:
(Sum(Demand)/12) * GetSelectedCount(Period)
Let me know if it helps.
-Zapparoli
Check my Youtube Channel for more Qlik Content
https://www.youtube.com/@ZappaAnalytics
Hi @John117
Maybe you can use the GetSelectedCount Function
Like this:
GetSelectedCount(Period)
Then on your Formula:
(Sum(Demand)/12) * GetSelectedCount(Period)
Let me know if it helps.
-Zapparoli
Check my Youtube Channel for more Qlik Content
https://www.youtube.com/@ZappaAnalytics
Hi @Zapparoli
thanks, that worked. Could swear I tried the same previously without the same result..
Cheers