Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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

View solution in original post

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

View solution in original post

Highlighted
Partner
Partner

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

Thanks for helping!!