topic Re: Need Help in QlikView

Need Help

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

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

Re: Need Help

miskinmaz — Fri, 09 Aug 2019 06:02:57 GMT

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)

Re: Need Help

smilingjohn — Fri, 09 Aug 2019 06:54:09 GMT

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

Re: Need Help

miskinmaz — Fri, 09 Aug 2019 06:53:44 GMT

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.

Re: Need Help

smilingjohn — Fri, 09 Aug 2019 07:02:25 GMT

Attaching Excel data ..

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

Thanks

Re: Need Help

miskinmaz — Fri, 09 Aug 2019 07:12:20 GMT

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 .

Re: Need Help

smilingjohn — Fri, 09 Aug 2019 09:13:16 GMT

This is not working

Re: Need Help

jensmunnichs — Fri, 09 Aug 2019 11:32:30 GMT

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.

Re: Need Help

Brett_Bleess — Tue, 27 Aug 2019 15:33:26 GMT

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