Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to exclude values from all calculations

Hi all. I have a table like this. I know that I don't need Напитки at all, but I can't exclude them from the database.

Can I make a vitiable in a load script that will automatically make smith like this: if salescript_group_name = "Напитки" then points = 0;

Thank you!

screenshot 5.png

1 Reply

Re: How to exclude values from all calculations

Hi Evgeniy, you can do in load script changing the way you load your Points field:

LOAD last_first_name,

     Points,

     If(salescript_group_name = 'Напитки', 0, PointsField) as Points

....

Community Browser