topic Re: NOT in load script if statement in QlikView

NOT in load script if statement

Wed, 25 Nov 2020 16:16:04 GMT

I have a massive list of suburbs for some data. I want to be able to filter for :

** Mount Isa

** Not Mount Isa

so that my audience can explore the data not in the main block. Mount Isa is the greatest amount of data, but we are also interested in what happens outside of it.

I know within the front end we can use the sum({$<Suburb-={'MOUNT ISA'}>}Count) to pick those which aren't Mount Isa with the -= syntax

How do I set it up in the load script to basically say

If the suburb = 'MOUNT ISA', 'MOUNT ISA' ,

otherwise if it is NOT 'MOUNT ISA' then 'Not MOUNT ISA'

as MtIsa_or_Not (Fieldname)

so I can create a filter list with just 'MOUNT ISA' and 'Not MOUNT ISA' for my audience to explore the data in these 2 areas.

Thanks

Re: NOT in load script if statement

vishsaggi — Mon, 25 Jul 2016 16:40:57 GMT

May be this?

If(Suburb = 'MOUNT ISA', 'MOUNT ISA', 'Not MOUNT ISA') AS MtIsa_or_Not

Re: NOT in load script if statement

Anonymous — Mon, 25 Jul 2016 17:11:32 GMT

Last time I went to Mount Isa I swallowed a fly.

Re: NOT in load script if statement

Mon, 25 Jul 2016 21:33:58 GMT

Lol poor fly

Re: NOT in load script if statement

Mon, 25 Jul 2016 21:37:45 GMT

So simple I can't believe I missed it - thanks - Doh!

Re: NOT in load script if statement

vishsaggi — Mon, 25 Jul 2016 22:01:25 GMT

Hello Clea,

Please close the thread if it answered your query. 🙂