Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Need Help

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.

reqPNG.PNG

My requirement is like.

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

reqa.PNG

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

re2.PNG

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

 

Please find the attachment of the Qlikview file

 

Thanks in Advance 

 

 

1 Solution

Accepted Solutions
jensmunnichs
Creator III
Creator III

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.

View solution in original post

8 Replies
miskinmaz
Creator III
Creator III

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
Specialist
Specialist
Author

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

 

result.PNG

 

 

 

Thanks 

 

miskinmaz
Creator III
Creator III

 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
Specialist
Specialist
Author

Attaching Excel data ..

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

 

Thanks 

miskinmaz
Creator III
Creator III

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
Specialist
Specialist
Author

This is not working

jensmunnichs
Creator III
Creator III

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
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.