I have data per month-end (stock-values per article)
If I set a filter on the month-end (say 6 months) the following happens:
In both cases, the active filter, shown in the headline of Qliksense shows correctly (6 of 51 filtered periods)
Am I doing something wrong or should I use a different formula ?
Based on the result of GetSelectedCount(Period), other figures such as average-consumption, days-of-inventory, etc. are calculated.
Solved! Go to Solution.
I was surprised by your observation. I would expect GetPossibleValues() to respond to the number of possible months -- I would not have expected GetSelectedCount to respond as well.
However, if you have a Period list box open when you select that item, you will see that only 2 of the periods will be green-highlighted, so both the listbox and GetSelectedCount seems to only consider selections from the possible values only.
I think you will need to find another way to get that count.
Do you think it could be a version problem?
I opened your Test.qvf in my Qliksense Desktop 3.2 SR1 version and I see 1 in both (the built-in filter on top and the Getselectedcount)
pls see attachement.
When using your formula, Filter set for Articles isn't working anymore and formula is only working for total table, not per row. But I need the formula-result per line as this is the basis for further calculations.
It seems, that we need a different approach as this is geeting complicated...