NOT in load script if statement

[#1]

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

[vishsaggi · Accepted solution]

May be this?

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

[Anonymous]

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

[#4]

Lol poor fly

[#5]

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

[vishsaggi]

Hello Clea,

Please close the thread if it answered your query. 🙂