Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
somenathroy
Creator III
Creator 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
Partner - Master III
Partner - Master III

hei

check this example

hope its helps you

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hei

check this example

hope its helps you

somenathroy
Creator III
Creator III
Author

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