topic Year calc in QlikView

Year calc

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Probably an easy answer but it's not working for me.

If I have year on one chart 2013 2014 2015 2016 2017 2018 (Year req)

And I want to use that field for only 2014 2015 2016 2017 on another chart, how do I hide 2013 & 2018 on this chart?

Do I need to create another field, (Year req2) or is there a way to manipulate the first field on the new chart?

Anonymous — Thu, 08 Feb 2018 19:59:20 GMT

Use

If(Wildmatch([Year req], '2013', '2018'), null(), [Year req])

as your chart dimension and uncheck 'Show null values' on the dimension.

Cheers,

Josefina

Anonymous — Thu, 08 Feb 2018 20:58:05 GMT

No this did not do it. I want the field across the top to be 2014 2015 2016 2017( Year Rqstd), and for the bar chart to only reflect those bars.