Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
smilingjohn
Contributor III

Accumulate Values

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

4 Replies
smilingjohn
Contributor III

Re: Accumulate Values

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

 

Thanks 

smilingjohn
Contributor III

Re: Accumulate Values

Waiting for some logic  to accomplish

Support
Support

Re: Accumulate Values

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

Re: Accumulate Values

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....

 image.png