Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
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