Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Highlighted
shahafei2
Contributor

How to allow data select in chart bar based on y axes

Hi all,

 

I Have number of bar chart objects in container object

i would like to create a variable for input box that will allow the user to pick what Y value will be the maximum 

and by setting this field the model will hide the irrelevant dates (x axes)

 

 

For example the first table summarize the sales per day for one of the sites

i would like that the user will be able to input 100,000 to the input box 

and that the model will auto select/filter the dates with the sum(sales) below 100,000  

2 Replies
mark6505
Valued Contributor III

Re: How to allow data select in chart bar based on y axes

Hi.

Create a variable vNUM.

Update your Set analysis to something like,

IF(SUM(sales)>=$(vNUM),SUM(Sales))

Mark

shahafei2
Contributor

Re: How to allow data select in chart bar based on y axes

It's doesn't work i set a var  (vMaxSales)

 

but when i tried to write the set analysis in the expression i received an error in the expression 

 

This is the expression that i'm trying to use

Sum({$<sum(Sales)=-{'$(vMaxSales)'}>}Sales)

 

Community Browser