topic Re: product selection in QlikView

product selection

Wed, 17 Jul 2013 16:49:26 GMT

I have requirement, where we have multiple products and some of them are Brands and competitors. I got to show two charts

1. show only branded item sales line chart

2. if user select brand product P1 all competitors and the selected brand products (P2,P3,P1) sale should show.

Please find the attached sample app.

is this feasible ?

LOAD * INLINE [

Date, Product,Type, Sales

20130101, P1,Brand, 10

20130201, P1,Brand, 15

20130301, P1,Brand, 5

20130401, P1,Brand, 10

20130101, P2,Competitor, 20

20130201, P2,Competitor, 10

20130301, P2,Competitor, 30

20130401, P2,Competitor, 5

20130101, P3,Competitor, 10

20130201, P3,Competitor, 30

20130301, P3,Competitor, 25

20130401, P3,Competitor, 30

20130101, P4,Brand, 20

20130201, P4,Brand, 40

20130301, P4,Brand, 30

20130401, P4,Brand, 35

];

Wed, 17 Jul 2013 16:56:34 GMT

SET ANALYSIS thare are a function you can do this !!!!

Wed, 17 Jul 2013 16:59:18 GMT

sum({1 - $} Sales)

Returns sales for everything excluded by the current selection.

Wed, 17 Jul 2013 17:04:02 GMT

Workit introducing the next in your exppesion for sales

sum ({1 - $} Sales)

jagan — Wed, 17 Jul 2013 17:29:46 GMT

Hi,

PFA file for solution.

Regards,

Jagan.