Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exclude a value in a chart

Hi there are a lot of answer on that subject but no one seem to work for me, so it may have been already answered.

I have a dimension 'IssuerSector' whitch can be '#N/A' I need to exclude this value in a chart.

I tried an if condition:
if(IssuerSector <> '#N/A', IssuerSector), or if(IssuerSector <> '#N/A', null(), IssuerSector).
It never worked. I even tried to replace it by another value: if(IssuerSector = '#N/A', IssuerSector = 'Government') it didn't work either.


How can I exclude this value?

Here a is the proporties, maybe I forgot something.

IssuerSector.png
Thanks in advance.


1 Solution

Accepted Solutions
Not applicable
Author

Hi,

try this but in Éditer:

if(IssuerSector <> '#N/A', IssuerSector)


and deselected "activer la condition"



View solution in original post

6 Replies
Not applicable
Author

Hi,

try this but in Éditer:

if(IssuerSector <> '#N/A', IssuerSector)


and deselected "activer la condition"



Not applicable
Author

The field you are using is to show or not the dimension itself (as a whole)

Create a calculated dimension (instead of your current dimension), and enter your equation:

if (xxxx <> '#N/A', xxxx)

Fabrice

giakoum
Partner - Master II
Partner - Master II

sum( {$<IssueSector = IssueSector - {"#N/A"}) >} Sales )

luis_pimentel
Partner - Creator III
Partner - Creator III

Use this

if(IssuerSector <> '#N/A', IssuerSector)

inestead of your current dimension. You can modify your current dimension with the Éditer button that you have in your snapshot.

Not applicable
Author

I just needed to modify the expression in the "Editer" section not in the field I was writing in, thanks a lot

Not applicable
Author

you welcome.