topic Re: How Show value just for 1 year in QlikView

How Show value just for 1 year

pascos88 — Mon, 02 Jul 2018 12:52:42 GMT

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 :

I would just have the point on 2018...

Any suggestion ?

Thanks

pascos88 — Mon, 02 Jul 2018 12:58:17 GMT

Solved with :

if (Year= 2018, count(Submitdate) )

.. other suggiostion are welcome

YoussefBelloum — Mon, 02 Jul 2018 13:00:39 GMT

Hi,

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

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