Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY

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'.



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.


Kindly leave any valuable comments.

The qvw is also attached below.


Thanks and regards,

Arthur Fong