topic Re: Set Analysis Issues in QlikView

Set Analysis Issues

ajithsachin — Wed, 05 Jun 2013 11:39:23 GMT

HI All,

I have a table like this.

if i select branch 1,i need to know item which is having stock and there is no sales and in second column need to show in which branch

that item is selling more and what is the sales qty.

my result chart should be like this

Itemcode	Stock	Branch which is having most sales	Sales
001	10	3	10

can anybody help please..

Regards,

Ajith

Gysbert_Wassenaar — Wed, 05 Jun 2013 11:57:14 GMT

See attached qvw

jagan — Wed, 05 Jun 2013 11:57:43 GMT

Hi Ajith,

Please find attached file for solution.

Regards,

Jagan.

sushil353 — Wed, 05 Jun 2013 11:57:44 GMT

Hi Ajith,

Please find attached qvw file..

HTH

Sushil