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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
linda394
Contributor
Contributor

If Statement and a certain Year selection

I want to Show in my Chart the value 0.8 for every year >2019 and if Year<=2018 the value 0.77 should be shown. Why does it only work when i don't select any month. I used following Formula:  IF(Year<2019,0.77,0.8).

If I select a month for the Year 2018 see appendix what happends

 
 
Labels (2)
2 Replies
dplr-rn
Partner - Master III
Partner - Master III

I am not clear on the issue. could you share a screenshot how it looks before month selection and after month selection.

Also which is the relevant expression is it the line or the bar?

linda394
Contributor
Contributor
Author

If I don't sselect a month, the right value for 2018 (0.77) is shown for every month. If I select a month,  the right value is only shown for the selected month. Thanks for helping.

 

 

 

Chart_before.PNG