Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

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
Highlighted
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
Highlighted
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)

Highlighted
Creator III
Creator III

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 

 

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

Highlighted
Creator III
Creator III

Attaching Excel data ..

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

 

Thanks 

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

Highlighted
Creator III
Creator III

This is not working

Highlighted
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

Highlighted
Digital Support
Digital Support

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.