topic Re: Grouping Issue in QlikView

Grouping Issue

jyothish8807 — Wed, 13 May 2015 09:01:14 GMT

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

Name	Type	Sale
A	master	1000
B	slave	236
C	slave	334
D	slave	321
E	master	2000
F	slave	324
G	slave	234

Requirement:
If I select Name=A			if I select name=B		if I select name=E
Final Sale	1000		Final Sale	236	Final Sale	2000
Group Sale	891		Group Sale	0	Group Sale	558

Regards

Re: Grouping Issue

Gysbert_Wassenaar — Wed, 13 May 2015 09:25:02 GMT

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

Re: Grouping Issue

jyothish8807 — Wed, 13 May 2015 09:28:33 GMT

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

Re: Grouping Issue

jyothish8807 — Wed, 13 May 2015 09:29:16 GMT

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

Regards

Re: Grouping Issue

Gysbert_Wassenaar — Wed, 13 May 2015 09:51:30 GMT

See attached qvw.

Re: Grouping Issue

jyothish8807 — Wed, 13 May 2015 10:40:28 GMT

Thanks a lot Gysbert, you are awesome

Regards

Jyothish KC

Re: Grouping Issue

anbu1984 — Wed, 13 May 2015 11:34:53 GMT

Check this app

Re: Grouping Issue

jyothish8807 — Thu, 14 May 2015 10:39:00 GMT

Thanks a lot anbu, even your solution worked.

Regards

Jyothish KC