topic Re: ignore a value in QlikView

ignore a value

Fri, 01 Jun 2012 06:13:46 GMT

hi all

i have a field SHIFT

SHIFT:

i want to ignore value D. how can i do.

Thanks

jonathandienst — Fri, 01 Jun 2012 06:26:39 GMT

You have not been very specific.

To exclude in script: LOAD A, B, C From Table;

To exclude in calc dimension: If(SHIFT <> 'D', SHIFT)

To exclude in expression: Sum({<SHIFT-={'D'}>} Value)

Hope that helps

Jonathan

Wed, 24 Apr 2013 19:33:00 GMT

Hi Jonathan,

If I could get more specific. In an expression on a pivot chart.

sum({<STEP_SECTION={"PAC"}>}QUANTITY) .....This works......

sum({<STEP_SECTION.={"PAC"}>}QUANTITY) .....This doesn't work...... And <> instead of .= doesn't work either.

I'm trying to exclude PAC instead of only include it.

Thanks

BobC.