topic Re: Selecting multiple values in field in Script in QlikView

Selecting multiple values in field in Script

Mon, 03 Aug 2015 22:52:08 GMT

My field name is Expense Type and I want to say

if([Expense Type] = 'Breakfast' OR [Expense Type] = 'Lunch' OR [Expense Type] = 'Dinner' OR [Expense Type] = 'Meals Other' AND [Expense Account] = 'Billable' AND [Total Spend] <= 100,1,0) as FlagMeals.

This is not working but essentially I need each expense type and if its billable and less than 100 total spend then flag as 1...

whats is the correct syntax withing the script editor for something like this?

Re: Selecting multiple values in field in Script

prabhu0505 — Mon, 03 Aug 2015 23:44:01 GMT

if(

(

[Expense Type] = 'Breakfast' OR [Expense Type] = 'Lunch' OR [Expense Type] = 'Dinner' OR [Expense Type] = 'Meals Other'

)

AND

(

[Expense Account] = 'Billable'

)

AND

(

[Total Spend] <= 100),1,0

)

as FlagMeals.

Something like this should work. Parentheses instruct which part to execute first.

Re: Selecting multiple values in field in Script

john9inno — Tue, 04 Aug 2015 00:10:32 GMT

you missed brackets but statement was fairly right.

one thing that i don't understand is below.

([Total Spend] <= 100)

isn't it supposed to be ([Total Spend] < 100) as you described less than 100 rather than less or equal to 100.

if(

(

[Expense Type] = 'Breakfast' OR [Expense Type] = 'Lunch' OR [Expense Type] = 'Dinner' OR [Expense Type] = 'Meals Other'

)

AND

([Expense Account] = 'Billable' )

AND

([Total Spend] < 100)

,1,0)

as FlagMeals

Re: Selecting multiple values in field in Script

Anonymous — Tue, 04 Aug 2015 00:42:03 GMT

If you really need "each expense type and if its billable and less than 100":

if([Expense Account] = 'Billable' AND [Total Spend] < 100,1,0) as FlagMeals

Re: Selecting multiple values in field in Script

robert_mika — Tue, 04 Aug 2015 02:53:18 GMT

if(Match([Expense Type] , 'Breakfast' , 'Lunch', 'Dinner' , 'Meals Other') AND [Expense Account] = 'Billable' AND [Total Spend] <= 100,1,0) as FlagMeals.

should perform better

Feeling Qlikngry?

How To /Missing Manual(18 articles)

Re: Selecting multiple values in field in Script

Mahamed_Qlik — Tue, 04 Aug 2015 04:28:27 GMT

Try this,

if(Wild Match([Expense Type] , 'Breakfast' , 'Lunch', 'Dinner' , 'Meals Other') AND [Expense Account] = 'Billable' AND [Total Spend] <= 100,1,0) As FlagMeals

Re: Selecting multiple values in field in Script

senpradip007 — Tue, 04 Aug 2015 04:55:58 GMT

Have got your desired result !!!!