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: 
jyothish8807
Master II
Master 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
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

7 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
jyothish8807
Master II
Master II
Author

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
Master II
Master II
Author

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

Regards

KC

Best Regards,
KC
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand
jyothish8807
Master II
Master II
Author

Thanks a lot Gysbert, you are awesome

Regards

Jyothish KC

Best Regards,
KC
anbu1984
Master III
Master III

Check this app

jyothish8807
Master II
Master II
Author

Thanks a lot anbu, even your solution worked.

Regards

Jyothish KC

Best Regards,
KC