Selection in Line chart

Thu, 06 Jan 2011 07:29:17 GMT

I have a two fields named bibserial and saleno where

bibserial saleno

1 14

2 15

3 16

4 17

.... .......

38 52

Now i have created Avg Price and a Tasting graph in Line chart with dimension saleno and for Avg Price The expression is avg(if(Price>0,NETAMT/SOLDWT)) and for Tasting Point the expression is (Avg (If(Leaf>0,Leaf)) + avg (If(Liquor>0,Liquor)) +avg (If(Infusion>0,Infusion)))/3. Now I have a selection box with Saleno, Garden,Centre and Financial Year.When i choose a particular saleno with Particular Garden, centre and Financial Year the chart shows only in dot for that particular saleno but i want to see all the Avg Price and Tasting point starting from saleno 14 upto the selected saleno say if i select saleno 28 it will show in line chart from saleno 14 to saleno 28.

Selection in Line chart

tresB — Thu, 06 Jan 2011 08:25:53 GMT

Hi,

Create a variable, MaxSale=max(saleno). Now use calculated dimension as : IF (saleno>=14 and saleno<=$(MaxSale), saleno).

hope this would help you.

regards, tresesco

Selection in Line chart

Thu, 06 Jan 2011 10:15:02 GMT

It does not works

topic Selection in Line chart in QlikView

Selection in Line chart

Selection in Line chart

Selection in Line chart