Changing Bar chart depending on two inputs.

somenathroy — Wed, 26 Oct 2011 04:32:03 GMT

Dear All,

I have a table of which fields are : Tdate, location, party and sales%.

I have two conditions:

1: sum(if(sales% > $(vSales),1,0))

[Description : For a party find out the number of different Tdate on which sales% is greater than the entered sales% in variable vSales on month basis.]

2: (Count(location & party) * $(vNos)) / 100

[Description : For a party find out the vNos percentage of the total number of Tdates on month basis.]

vSales and vNos are two input variables.

My requirement is to make a Bar chart which will show the number of 'party's having the value of condition 1 is greater than condition 2 of different 'location's on monthly basis.

For ready reference I am attaching a qvw and a xls file.

Any help would be highly appreciated.

Thanls & Regards,

Somnath

Re: Changing Bar chart depending on two inputs.

lironbaram — Wed, 26 Oct 2011 07:13:44 GMT

hei

check this example

hope its helps you

Changing Bar chart depending on two inputs.

somenathroy — Wed, 26 Oct 2011 10:37:47 GMT

Thanks a lot liron baram. This is the exact result which I was looking for.

topic Changing Bar chart depending on two inputs. in QlikView

Changing Bar chart depending on two inputs.

Re: Changing Bar chart depending on two inputs.

Changing Bar chart depending on two inputs.