How to exclude a value from a field in Qliksense

[ramcena306]

Hello Everyone,

I have a field Order which has values like "LA","SA","RA","MA","GR"

i want to exclude "RA" when i enter one report.

Please help me on this..

Thanks,

Ram

[BrunPierre]

Perhaps with Match() in the script as below

Load *,

IF(not Match(Order,'RA'),Order) as OrderDim //Use field as a dimension and suppress when its null

From DataTable;

or

In an expression like this

AggregationFunction({<Order={'*'}-{'RA'}>}YourMeasure)

[ramcena306]

Hello BrunPierre,

Thank you for the replay, i want to apply this as a sheet action, please tell me how to apply that.

[BrunPierre]

Check here: Adding actions to sheets - Qlik Sense