Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

NOT in load script if statement

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

1 Solution

Accepted Solutions
vishsaggi
Esteemed Contributor III

Re: NOT in load script if statement

May be this?

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

View solution in original post

5 Replies
vishsaggi
Esteemed Contributor III

Re: NOT in load script if statement

May be this?

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

View solution in original post

Re: NOT in load script if statement

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

Not applicable

Re: NOT in load script if statement

Lol poor fly

Not applicable

Re: NOT in load script if statement

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

vishsaggi
Esteemed Contributor III

Re: NOT in load script if statement

Hello Clea,

Please close the thread if it answered your query. 🙂