topic Show a regressive count on chart/table in QlikView

Show a regressive count on chart/table

brunolelli87 — Wed, 25 Nov 2020 16:16:04 GMT

Dears,

I'm using the following expression to count the number of VDAA between two dates:

=count({<PERI={">=$(=addyears(FirstSortedValue(TOTAL PERI, LOPP), -1))<=$(=max(PERI))"}>} VDAA)

But this expression is working perfectly just in case of using it on a TextField.
When using it on a chart or table I'm getting numbers os 1 and 0, and basically the system is summing the values...

Check the pictures below:
As you can see below, at the column TESTE I'm getting values of 1 or 0 (you can't see it, sorry... )

But, I would like to get values as you can see below:

What should I do?
Thank you so much!

Re: Show a regressive count on chart/table

brunolelli87 — Sun, 17 May 2020 00:10:31 GMT

Any suggestion people?

Re: Show a regressive count on chart/table

Taoufiq_Zarra — Sun, 17 May 2020 00:30:34 GMT

can you share a sample data or qvw file ?

I'm not sure if I understood correctly the goal

Re: Show a regressive count on chart/table

brunolelli87 — Sun, 17 May 2020 00:39:01 GMT

Yes...

Take a look at my project!

As you can see on my project, the column TESTE is showing 1 or 0, but I would like to show the how many PERI we have from that day and =addyears(FirstSortedValue(PERI, LOPP), -1)...

In other words, I would like to show the number of items in column PERI between the PERI's Date and the expression =addyears(FirstSortedValue(PERI, LOPP), -1)

So, I'm expecting something like this:

Could you please help me providing the expression or script?
Once I'm using a Personal Edition I can not open your file...

Thanks

Re: Show a regressive count on chart/table

Taoufiq_Zarra — Sun, 17 May 2020 01:13:13 GMT

if I understand correctly.

and since PERI is a date +1 (sequence)

maye be :

=count({<PERI={">=$(=addyears(FirstSortedValue(TOTAL PERI, LOPP), -1))<=$(=max(PERI))"}>} total VDAA)-rowno()+1

output :