Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
static_abhi
New Contributor II

Re: How to divide a row with sum of specific rows of same column?

Yes, Blank or "-" whatever should come but above calculation should be the output

Re: How to divide a row with sum of specific rows of same column?

I used the exact same expression (except removing unwanted things)

=Sum(Orders)/

If(Match(Group, 'Appliance Refinishing', 'Appliance Repair - Large'), Sum(TOTAL {<Group = {'Appraisals - Real Estate','Architects & Building Design','Artwork/Murals'}>}Orders),

If(Group = 'Appliance Repair - Small', Sum(TOTAL {<Group = {'Asbestos Removal'}>}Orders),

If(Group = 'Appliance Sales', Sum(TOTAL {<Group = {'Auction Services'}>}Orders))))

to get this

Capture.PNG

This matches exactly with your Excel... is that not what you want?

View solution in original post

Highlighted
static_abhi
New Contributor II

Re: How to divide a row with sum of specific rows of same column?

Okay.. but sometimes i don't get one or two out of these.. That's fine.. Thanks for your help!

Highlighted

Re: How to divide a row with sum of specific rows of same column?

May be there is a mismatch in the name either in the Match statement or within the set analysis may be? Difficult for me to say without having a look at this

Highlighted
static_abhi
New Contributor II

Re: How to divide a row with sum of specific rows of same column?

Sure.. You may have a look.. I'm tired of finding bugs..

Highlighted

Re: How to divide a row with sum of specific rows of same column?

Once again, I fail to understand the use of dummy data with original application?

Capture.PNG

Also, some of the things are not available here

Capture.PNG

Asbestos Removal and Auction Services are missing from Class or Group....

Highlighted
baltazarj
New Contributor

Re: How to divide a row with sum of specific rows of same column?

I have experience now the same issue. I got my answer after I select up to the third filter. I have wrong answer when I only select something from first and second filter. Why do I need to select up to the third filter? I also want to get my answer even I only first or up to second filter.

 

Thank you in advance.