Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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