Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Champion III
Champion III

May be this?

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

View solution in original post

5 Replies
vishsaggi
Champion III
Champion III

May be this?

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

bill_markham
Champion III
Champion III

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

Not applicable
Author

Lol poor fly

Not applicable
Author

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

vishsaggi
Champion III
Champion III

Hello Clea,

Please close the thread if it answered your query. 🙂