topic Re: Accumulate Values in QlikView

Accumulate Values

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

Hi All

i have 3 tables

Table 1 , Table2 and detailed table .

In table 1 i will be showing only the count of open by month year

in table 2 i i will be showing accumulate of the opne counts

which is correct .

Currently i have selected jan-2017 in the Table 2 and in detailed table I should get the ID's from Dec-2016 and Jan-2017

( The Detailed table should display all the Id's including current Selected monthyear and Id's before that.
If I select Feb-2017 which is 39 , then in the detailed table it should show me the ID's from Dec-2016 till Feb -

Thanks in advance

Re: Accumulate Values

smilingjohn — Thu, 08 Aug 2019 12:55:28 GMT

Please can any expert look into this , It would be really helpful

Thanks

Re: Accumulate Values

smilingjohn — Thu, 08 Aug 2019 16:56:52 GMT

Waiting for some logic to accomplish

Re: Accumulate Values

Brett_Bleess — Tue, 27 Aug 2019 12:58:06 GMT

John, about the best I have is some Design Blog posts that may help you get on the right track with things...

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

https://community.qlik.com/t5/Qlik-Design-Blog/Accumulations/ba-p/1466581

Hopefully those may help you get things sorted. You back things up to the following URL and do your own searching as well if these are not quite on target:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

Re: Accumulate Values

sunny_talwar — Tue, 27 Aug 2019 13:09:57 GMT

I think all you need is to use a straight table instead of a table box to display what you want. Basically, try using set analysis in your expression

Count({<MonthYear = {"<=$(=MaxString(MonthYear))"}>}Open)

and you hide to display the expression....