Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
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.
Regards,
Reinhold
Not sure if I understand completely, but can you use this
Count(DISTINCT {1<Period = $::Period>} Period)
Hello Reinhold,
Could you please share the application with sample data?
Regards!
Rahul
I attached a sample-qvf where the situation is easily shown.
I also attach a screenshot showing the problem.
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.
Yes, that's right.
Both (GetSelectedCount and GetPossibleValues) respond 2.
Not sure if I understand completely, but can you use this
Count(DISTINCT {1<Period = $::Period>} Period)
Could you kindly explain this formula as the result is ok now, but for some reason, other filters on the table (e.g. article) do not work anymore.
This specific expression ignores all selections except for selection in Period field. What exactly are you looking to get?
Hi,
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...