Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
ABC
Contributor
Contributor

Bars in bar chart based on range

Hi,

I have a min value in a variable ( May -2018). I have a max value in a variable ( 0ct-2019). I have a column in a table with the months from 2017 to 2020. I need to create a bar chart within this range ( min value to max value). Can anyone help me fix this.

Thanks in advance.

 

Labels (1)
1 Reply
Dalton_Ruer
Support
Support

Here is a quick and dirty example:

=If(DateField >= $(vMinDate) and DateField < $(vMaxDate), DateField)

Note: In my examples the variables themselves contain single quotes around the values and that I purposely showed >= to the MIN date, but just < the MAX date. Change accordingly. 

Be sure to uncheck the "Include null values" box to avoid showing the others as a gray bar