topic Re: Condition not working in QlikView

Condition not working

deepakqlikview_123 — Thu, 11 Aug 2016 17:08:58 GMT

Hi all ,

My condition for set analysis for previous year is not working can you please suggest on this.

Below is the condition,

if((Sum({<Head = {'Bcone'},FlagNum = {"$(vAttriationFlagNum)"},Year={'$(=(max(Year)-1))'},Month_Num={'<=$(=max(Month_Num))'}>}Attrition))

=0,

((Sum({<Head = {'Bcone'},FlagNum = {"$(vAttriationFlagNum)"},Year={'$(=(max(Year)-2))'},Month_Num={'<=$(=max(Month_Num))'}>}Attrition))),

((Sum({<Head = {'Bcone'},FlagNum = {"$(vAttriationFlagNum)"},Year={'$(=(max(Year)-1))'},Month_Num={'<=$(=max(Month_Num))'}>}Attrition)))))

vinieme12 — Thu, 11 Aug 2016 17:13:45 GMT

if((Sum({<Head = {'Bcone'},FlagNum = {"=$(vAttriationFlagNum)"},Year={'$(=(max(Year)-1))'},

Month_Num={"<=$(=max(Month_Num))"}>}Attrition))

vinieme12 — Thu, 11 Aug 2016 17:14:35 GMT

i think you can also try Year without ' quotes Year={$(=(max(Year)-1))}

deepakqlikview_123 — Thu, 11 Aug 2016 17:35:02 GMT

Hi Vineeth,

Month_num is still not working

thanks

vinieme12 — Thu, 11 Aug 2016 17:48:14 GMT

Strange, does max(Month_Num) evaluate correctly in a text box? ARE both Numeric fields?

try below :

if(Sum({<Head = {'Bcone'},FlagNum = {"=$(vAttriationFlagNum)"},Year={$(=(max(Year)-1))}

,Month_Num={"<=$(=max(Month_Num))"}>}Attrition)=0, //Then

Sum({<Head = {'Bcone'},FlagNum = {"=$(vAttriationFlagNum)"},Year={'$(=(max(Year)-2))'}

,Month_Num={"<=$(=max(Month_Num))"}>}Attrition), //Else

Sum({<Head = {'Bcone'},FlagNum = {"=$(vAttriationFlagNum)"},Year={'$(=(max(Year)-1))'},

Month_Num={"<=$(=max(Month_Num))"}>}Attrition)

)

deepakqlikview_123 — Wed, 17 Aug 2016 14:51:57 GMT

Hi All,

Year={'$(=(max(Year)-1))'} is not working in set analysis here

Thanks

vishsaggi — Wed, 17 Aug 2016 15:20:11 GMT

Try this:

Year = { $(= max(Year)-1)) }