topic Re: Problem in indirect set analysis in QlikView

Problem in indirect set analysis

Fri, 09 Oct 2015 21:30:24 GMT

Hi all,

I have data like

Rep	Item	Sales
Stella	Iphone	15000
Parker	Iphone	25000
Micheal	Iphone	25400
Stella	Samsung	14200
Parker	Samsung	2300
Micheal	Samsung	14500

and i want to to display the representative who has sell only Iphones, for that i had written set expression as below

sum({$<Rep=P({1<Item={'Iphone'}>}Rep)>}Sales);

This expression shows all the rows, but i want the output like

Rep	Item	Sales
Stella	Iphone	15000
Parker	Iphone	25000
Micheal	Iphone	25400

Regards

Kalyan

Re: Problem in indirect set analysis

sunny_talwar — Fri, 09 Oct 2015 21:35:56 GMT

May be try:

Sum({<Item = {'Iphone'}>}Sales)

Re: Problem in indirect set analysis

sunny_talwar — Fri, 09 Oct 2015 21:37:13 GMT

Your expression -> sum({$<Rep=P({1<Item={'Iphone'}>}Rep)>}Sales)

is summing sales for all Reps who sell Iphone and since all of them sell Iphone you see them all.

Re: Problem in indirect set analysis

nizamsha — Sat, 10 Oct 2015 17:18:53 GMT

While writing a condition for iphone u have to write item=iphone but u have written rep=iphone

sum({$<Item={'Iphone'}>}Sales)

=sum({$<Rep=p({$<Item={"IPhone"}>}Rep)>}Sales)

it will work

=sum({$<Rep=p({1<Item={"IPhone"}>}Rep)>}Sales)

Re: Problem in indirect set analysis

MarcoWedel — Sun, 11 Oct 2015 00:53:40 GMT

Hi,

for salesmen who sold only iPhones, you could use:

=Sum({$<Rep={"=Only(Item)='iPhone'"}>} Sales)

hope this helps

regards

Marco

Re: Problem in indirect set analysis

Sun, 11 Oct 2015 07:32:20 GMT

Hi Ravuri

You can use one of either way

1- sum({<F2={'Iphone'}>}F3) as suggested by Sunny

2-if(F2='Iphone',sum(F3))

See attached for details.

Re: Problem in indirect set analysis

Anonymous — Sun, 11 Oct 2015 10:25:58 GMT

Hi,

I hope attached Application Helps you.

Thanks

Bunny

Re: Problem in indirect set analysis

maxgro — Sun, 11 Oct 2015 10:28:53 GMT

another solution for salesmen who sold only iPhones (using Marco test data)

=Sum({$<Rep={"=count(distinct Item)=1"},Item={iPhone}>} Sales)

Re: Problem in indirect set analysis

MarcoWedel — Sun, 11 Oct 2015 21:08:05 GMT

also possible:

=Sum({$<Rep-=p({$<Item={"=Item<>'iPhone'"}>} Rep)>} Sales)

regards

Marco