Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
Partner
Partner

Expression to show N/A when a dimension is selected

Hi all,

I have a requirement to show 'N/A' for a specific dimension value throughout the months. 

Below is the expected output (without selection):

          Month for Feb, Jun, and Oct are displayed as 'N/A'.

WithoutSelections.PNG

 

I would also want to achieve the desired output when Month is selected:

For example when i select Apr, Month for Feb, Jun, and Oct should be displayed as 'N/A'.

But I couldn't achieve the expected result.

WithSelections.PNG

Kindly leave any valuable comments.

The qvw is also attached below.

 

Thanks and regards,

Arthur Fong