topic Re: Set analysis for Filters in QlikView

Set analysis for Filters

Raggs — Tue, 15 Sep 2020 13:52:07 GMT

Hello Team,

I have a data as below, I need the output as % Values calculate on sales based on the Filter type only.

example: A = Allowance, V=Incentive, M=Margin

Filter Type	%Values
A	2.00
A	1.30
V	0.56
A	5.00
V	6.00
M	4.30
V	2.40
M	8.50
A	10.00

Can you please help me on this with set analysis.

Thanks in advance.

Re: Set analysis for Filters

sunny_talwar — Tue, 15 Sep 2020 16:10:40 GMT

Based on the sample data shared, what would be the output you would expect to see?

Re: Set analysis for Filters

Raggs — Wed, 16 Sep 2020 04:19:33 GMT

Hello Sunny,

Please find the below table for your reference

Filter Type	Item#	%Values	Sales Value	Allowance	Incentive	Margin
A	1235-5	2.00	1000	Here we need to calculate the Allowance % on particular Item sales and That calculated value should reflect here	Here we need to calculate the Allowance % on particular Item sales and That calculated value should reflect here	Here we need to calculate the Allowance % on particular Item sales and That calculated value should reflect here
A	1236-7	1.30	1500
V	1235-6	0.56	2000
A	1236-8	5.00	2500
V	1235-7	6.00	3000
M	1236-9	4.30	3500
V	1235-8	2.40	4000
M	1236-10	8.50	4500
A	1235-9	10.00	5000

Thanks in advance.

Re: Set analysis for Filters

Brett_Bleess — Thu, 24 Sep 2020 19:53:39 GMT

@sunny_talwar Poster came back with expected output, am guessing we may still be having notification issues in Community, sorry about that, if you have time to have another look at things, much appreciated.

Regards,
Brett