topic Re: Include numbers but exclude during calc in QlikView

Include numbers but exclude during calc

Thu, 12 Feb 2015 13:43:15 GMT

I have a number range 1-1000 which I successfully import.

No 15,25,50,75 and 90, I need to exclude from all calculations but later on a seperate sheet display my analysis.

How do I go about doing this.

My statement reads as follows -

If([number] >=1 and [number] <= 10000, 'Valid','Not defined') as d_type

Re: Include numbers but exclude during calc

giakoum — Thu, 12 Feb 2015 13:51:36 GMT

create a flag for these numbers as a new field and use it in set analysis

if([number]=15 or [number]=25 or [number]=50 or [number]=75 or [number]=90, 1, 0) as CalculateFlag

Re: Include numbers but exclude during calc

anbu1984 — Fri, 13 Feb 2015 03:01:00 GMT

If( ([number] >=1 and [number] <= 10000) And Not([number]=15 or [number]=25 or [number]=50 or [number]=75 or [number]=90), 'Valid','Not defined') as d_type

Re: Include numbers but exclude during calc

AbhijitBansode — Fri, 13 Feb 2015 05:44:12 GMT

If(

([number]>=1 and [number]<=10000)

and not Match([number],15,25,50,75,90),

'Valid','Not defined'

) as d_type

Re: Include numbers but exclude during calc

jonathandienst — Fri, 13 Feb 2015 05:48:15 GMT

I am assuming from your post that you want to load these numbers, but exclude them from your calculation(s). Thne use the following set expression to exclude them:

Use it in an expression like this for example:

Sum({<number -= {15,25,50,75,90}>} amount)

The -= will flag as a syntax error in the expression editor. This is a bug in the syntax check, so just ignore this warning.

HTH

Jonathan