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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
pascos88
Creator II
Creator II

How Show value just for 1 year

Hello,

I have this chart and now for 'Actual I want just show point for 2018..

The function for actual is :

count({$<Year = {'2018'}>}Submit) and the result is :

J2018.PNG

I would just have the point on 2018...

Any suggestion ?

Thanks

2 Replies
pascos88
Creator II
Creator II
Author

Solved with :

if (Year= 2018, count(Submitdate)  )

.. other suggiostion are welcome

YoussefBelloum
Champion
Champion

Hi,

you have 3 expressions on your chart, you should add this to every expression:

{$<Year = {'2018'}>}