Exclude one field value

[Saiteja1]

Hi 

I have one table in qliksense . I need to exclude one value called (Other Not Mapped) in a field called (State). How can I exclude  it in only that table in qliksense

Please give me some suggestions to exclude that value 

[abhijitnalekar]

Hi @Saiteja1 ,

Can you please elaborate on the scenario?

as you want to exclude from whole or it is restricted only for chart or table  

[Saiteja1]

It is restricted only for that chart . Not in script 

[Anku]

@Saiteja1  try

IF( State like 'Other Not Mapped','',State)

[Saiteja1]

@Anku 

It is not working

[Anku]

@Saiteja1 

State is your dimension. Right?

If( State <>'Other Not Mapped', State,'')

Though it's also similar to the below one.

Check

1. case sensitivity,

2. Uncheck include null values from dimension and zeros from add-on-> data handling-> uncheck

Also, check is there any limitation applied under the dimension.

[jmartineze]

Hi, 

use set analysis in your measure.

Like this: count( {<[Other Not Mapped]=-{'State'}>} Field)