Need Help

[smilingjohn]

Hi All.

Please find the attachment of the QVW file in which i have two tables 1. Total Accumulate and Table 2.

as shown in the screenshot below.

My requirement is like.

In Total accumulate if i click on march month which has accumulated 6 sales. as shown in below fig

the it should show me the breakdown of 6 sales in the tables like below screenshot.

I am struggling to get this . help will be really great full.

Please find the attachment of the Qlikview file

Thanks in Advance 

[miskinmaz]

For total accumulate count you can try the below expression

sum(aggr(Sum(total {<Month={"<=$(=max(Month))"}>}sales),Month))

and for the detail breakdown you can try

=Sum( {<Month={"<=$(=max(Month))"}>}sales)

[smilingjohn]

Thanks for the reply Miskinmaz

I tried with your expression but the table are not showing anything , it seems to be wrong . 

Below is the screenshot after adding the expressions

Thanks 

[miskinmaz]

 I don't have the qlikview to view your application.

You have to check the format of month and what format max(Month) is giving. It is just a format issue I am thinking.

Also I hope that Month is not a string but a date.

[smilingjohn]

Attaching Excel data ..

and I have converted Month to date in script as well as in excel format. 

Thanks 

[miskinmaz]

Sorry I can't help you with the excel file.

Try to add one more expression  -  max(Month) in a table and see what it is returning. If it is a num then format it .

[smilingjohn]

This is not working

[jensmunnichs · Accepted solution]

Hey,

Have a look at the attached file. I had to add an extra column to turn the month names into numerical values, otherwise the set analysis in the second table wouldn't work.

Also works for multiple month selections.

Let me know if this works for you and/or if you have any questions.

P.s. credit for the cumulative sum goes to this post.

[Brett_Bleess]

John, did Jens' last post do the trick for you?  If so, please consider giving him credit for the help by using the Accept as Solution button on that post.

Regards,
Brett