topic Expression - Return result if figure does not equal zero in QlikView

Expression - Return result if figure does not equal zero

Wed, 29 Jun 2011 10:02:54 GMT

I have a straight table that has a number of expressions which return numeric figures. On one of the expressions I need to filter out anything that does not equal zero. My current expression is Sum(Settled). What should my expression be to return: sum(settled), only if settled does not equal zero? The result would be that the straight table only shows results when the settled figure is not zero, regardless of what the other expressions return.Thanks.

Expression - Return result if figure does not equal zero

kaushiknsolanki — Wed, 29 Jun 2011 10:10:59 GMT

Hi,

You can use the set analysis for this. For example.

Sum({<Settled -= {"0"}>}Settled)

This will give you sum only when the settled is not 0.

Regards,

Kaushik Solanki

Expression - Return result if figure does not equal zero

Wed, 29 Jun 2011 10:22:47 GMT

Thanks - I've tried that but its not working. Is it becasue all of the other expressions in the table need to contain the same statement - for example one column shows Tax - should I use Sum({<Settled -= {"0"}>}Tax) and so on for other expressions? Thanks.

Expression - Return result if figure does not equal zero

kaushiknsolanki — Wed, 29 Jun 2011 10:32:35 GMT

Hi,

Yes, you are right.

If you provide qvw file, that will help me to understand it properly.

Regards,

Kaushik Solanki

Expression - Return result if figure does not equal zero

Wed, 29 Jun 2011 10:44:58 GMT

Thanks I have updated the other expressions and it now works