Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

somenathroy
Contributor III

Changing Bar chart depending on two inputs.

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

1 Solution

Accepted Solutions
lironbaram
Honored Contributor II

Re: Changing Bar chart depending on two inputs.

hei

check this example

hope its helps you

2 Replies
lironbaram
Honored Contributor II

Re: Changing Bar chart depending on two inputs.

hei

check this example

hope its helps you

somenathroy
Contributor III

Changing Bar chart depending on two inputs.

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

Community Browser