Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

 

1 Solution

Accepted Solutions
punitpopli
Contributor III

Re: Expression to show N/A when a dimension is selected

please find the attached QVW file and check if this helps, as this is working fine for me

2 Replies
punitpopli
Contributor III

Re: Expression to show N/A when a dimension is selected

please find the attached QVW file and check if this helps, as this is working fine for me

Highlighted
Partner
Partner

Re: Expression to show N/A when a dimension is selected

Thanks for helping!!