Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
jyothish8807
Honored Contributor II

Grouping Issue

Hi All,

I am stuck with a requirement: I have a table like this below. I want to group the sum on my Type, if i select a Master then final Sale should be his Sale and Group Sale should be his slave sales and if i select a Slave then Final sale should be his sale and Group sale should be '0'.

        

NameTypeSale
Amaster1000
Bslave236
Cslave334
Dslave321
Emaster2000
Fslave324
Gslave234
Requirement:
If I select Name=Aif I select name=Bif I select name=E
Final Sale1000Final Sale236Final Sale2000
Group Sale891Group Sale0Group Sale558

Regards

KC

Best Regards,
KC
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Grouping Issue

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

7 Replies
MVP & Luminary
MVP & Luminary

Re: Grouping Issue

Where's the data that links masters and slaves to groups?


talk is cheap, supply exceeds demand
jyothish8807
Honored Contributor II

Re: Grouping Issue

Hi Gysbert,

I dont have any data other than this linked to it. According to the table all slave mentioned below the master falls in his group. So i am trying to bucket them.

Regards

KC

Best Regards,
KC
jyothish8807
Honored Contributor II

Re: Grouping Issue

Final Sale and group sale are expression i need to create.

Regards

KC

Best Regards,
KC
MVP & Luminary
MVP & Luminary

Re: Grouping Issue

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

jyothish8807
Honored Contributor II

Re: Grouping Issue

Thanks a lot Gysbert, you are awesome

Regards

Jyothish KC

Best Regards,
KC
Highlighted
anbu1984
Honored Contributor III

Re: Grouping Issue

Check this app

jyothish8807
Honored Contributor II

Re: Grouping Issue

Thanks a lot anbu, even your solution worked.

Regards

Jyothish KC

Best Regards,
KC