topic Re: Only display certain Dimension Values in QlikView

Only display certain Dimension Values

peterderrington — Mon, 30 Nov 2020 16:39:28 GMT

I have a straight Table and only want to display certain dimension values within it.

I tried this expression as a Conditional within the dimensions section but it didn't get rid of the other months:

=if(MonthYear<>'Apr 2020''May 2020''Jun 2020''Jul 2020''Aug 2020''Sep 2020''Oct 2020''Nov 2020',MonthYear)

Any ideas?

Thanks.

Re: Only display certain Dimension Values

Nicole-Smith — Mon, 30 Nov 2020 19:00:02 GMT

This should work (you want it as the dimension, not the conditional--the condition shows/hides the entire column, not values within it):
=if(not match(MonthYear,'Apr 2020','May 2020','Jun 2020','Jul 2020','Aug 2020','Sep 2020','Oct 2020','Nov 2020'), MonthYear)

Re: Only display certain Dimension Values

peterderrington — Tue, 01 Dec 2020 08:35:02 GMT

Thanks for this, i had to drop the "not" function so it would only show the months in the expression (which is what i wanted - sorry if i didnt explain that properly) however there now seems to be an extra line in the dimensions plus the order isnt right which i tried to solve with a Match expression in the Sort tab but no difference. Sure i'm missing something obvious.

Re: Only display certain Dimension Values

richard_chilvers — Tue, 01 Dec 2020 08:53:22 GMT

I'm not sure you can use not equals in this way in Qlik. Assuming the values are correct for your field called MonthYear, I'd use the MATCH function, ie:
=IF(MATCH(MonthYear, 'Apr 2020', 'May 2020' ......)=0, MonthYear)