Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Mark18
Contributor II
Contributor II
‎2021-05-05 03:55 AM

Bar chart between two months

Hi guys,

I have two variables vFrom and vTo.

Which will be set based on user selection from a drop down. The variables holds the MonthName value eg.Feb 2017.

How can i plot a barchart between the From and To month.

Im using expression linke this in the dimension:

If(monthYear> $(vFrom) and monthYear<$(vTo), monthYear)

But it is not working. monthYear is the column from the table which is also a MonthName field.

 

296 Views
0 Likes
1 Reply
Dalton_Ruer
Support
Support
‎2021-05-05 10:01 AM

The expression editor will show you how it is evaluating your expression at the bottom of the screen. It will say OK when it's good to go, or will show errors. Typically for things like dates you might need to wrap them with single quotes so they come out look like they need division done

If(monthYear > 12/5/2021  

Of it might show 0 or something because the value is jacked up. 

If you wrap '$(vFrom)' it will add the single quotes around the value so the bottom of the screen should show

If(monthYear > '12/5/2021'

258 Views
0 Likes