Discussion Board for collaboration related to QlikView App Development.
So I have a table similar to the one below:
I used the following expression to get the third column:
=Count(TOTAL<ID> DISTINCT Date)
However, I need a fourth column to show me the cumulative number of duplicates based off order of the date:
How would I formulate an expression to create the fourth column?
There you go:
Create the cumulative logic at script level using peek() function.
First, sort your data by ID, then Date.
Then apply peek function to get the result as below:
Refer qvw attached for reference.
Thanks and regards,
View solution in original post
Isn't this all you want? Make sure the dates are numbers behind the scene, not texts.
Also sort order must be ID first, and then Date.
That worked great thank you so much!