topic Re: Distinct values as of time in App Development

Distinct values as of time

johanfo2 — Wed, 03 Nov 2021 12:25:54 GMT

Hi,

I am trying to create a graph showing the number of distinct values (y-axis) over time (x-axis) for a dataset.

Say:

Time, Value
1,A
2,A
3,B
4,C
5,A
6,Q
etc

So the graph shows the total number of distinct value as of that time. At time=1 it is "1" and at time=6 it is "4" in the above example. After plenty of searches, I have concluded that this is only possible to do during the loading phase (in the script), and that no runtime script solution exists to this problem. I'm I right, or wrong 🙂 ?

Re: Distinct values as of time

brunobertels — Wed, 03 Nov 2021 12:50:08 GMT

May be try this

aggr(rangesum(

above(

sum(

aggr(

count(distinct "Value")

,"Value")

)

,0,RowNo())),Time,(Numeric))

)

Re: Distinct values as of time

CurtDaughtryBP — Wed, 03 Nov 2021 13:15:41 GMT

Would the accumulation option within the measure modifier be an option? Or using an accumulation technique?

Essentially you are looking for count(distinct Value) grouped by Time. Time is the dimension, count distinct is the measure.

The only difference is that you are trying to accumulate the distinct count over time. Is that correct?

This link shows using the rangesum(above( technique as an alternative approach but I think it may still be a viable path if you wanted.

Hope that helps.

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis/ba-p/1468497

https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/Visualizations/Table/table-example.htm