Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
shahafei2
New Contributor III

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
New Contributor III

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