Exclude value from a dimension not used in table when Dimensions does not give you option to exclude null values

[qliknewbie_1]

Hi,

I have a table where i would like to exclude one value from a dimension I'm not using in the table, but need to exclude. I've done this before with a if statement like this

= if(category <> 'Value', dimension)

And then I've unchecked the "Include null values option.

However, now I have a table where this option does not exist. How can I solve this then?

Thanks

[krishna_2644]

Try:

Aggr(Only({$<category -= {"Value"}>}dimension), dimension)