topic Re: IF Condition Formula with Exclusion in QlikView

IF Condition Formula with Exclusion

Anonymous — Tue, 03 Dec 2013 01:17:47 GMT

Hello! Pls. help me fix my formula in my chart expressions.

This is my current formula that works currently where it's applicable to all field TYPE ...

IF ([Status]='Active',SUM({<KeyFig3= {'Demand'}>} Value),SUM({<KeyFig2 = {'ActualPO}>} Value))

However , I need to revise the formula that it will be applicable only if the field TYPE = CD...Thus, If TYPE <>CD,the should be SUM({<KeyFig3= {'Demand'}>} Value)

Tks.

Re: IF Condition Formula with Exclusion

Sokkorn — Tue, 03 Dec 2013 01:29:03 GMT

Hi,

I may not understand you well, but let give a try

IF ([Status]='Active' and [TYPE]<>'CD',SUM({<KeyFig3= {'Demand'}>} Value),SUM({<KeyFig2 = {'ActualPO}>} Value))

Regards,

Sokkorn

Re: IF Condition Formula with Exclusion

jagan — Tue, 03 Dec 2013 02:45:30 GMT

HI,

If you want to compare multiple conditions in If() then use AND/OR like below

IF ([Status]='Active' AND [TYPE] <> 'CD',SUM({<KeyFig3= {'Demand'}>} Value),SUM({<KeyFig2 = {'ActualPO}>} Value))

Regards,

Jagan.

Re: IF Condition Formula with Exclusion

Anonymous — Tue, 03 Dec 2013 16:50:48 GMT

Hi! Jagan,

I already tried to use this formula before ( also used OR) but it didn't work...

THE Type field varies by Status...like CD type could be active or inactive... What I like is when the Type is CD whether Status is active or inactive it will be SUM({<KeyFig3= {'Demand'}>} Value)...Otherwise, If the TYPE it's not CD then the IF condition applies IF ([Status]='Active' ,SUM({<KeyFig3= {'Demand'}>} Value),SUM({<KeyFig2 = {'ActualPO}>} Value))...

I hope I have explained this better...

Tks.