Re: Condition not working - Qlik Community

deepakqlikview_123 · ‎2016-08-11

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 · ‎2016-08-11

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

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

vinieme12 · ‎2016-08-11

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

deepakqlikview_123 · ‎2016-08-11

Hi Vineeth,

Month_num is still not working

thanks

vinieme12 · ‎2016-08-11

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)

)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

deepakqlikview_123 · ‎2016-08-17

Hi All,

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

Thanks

vishsaggi · ‎2016-08-17

Try this:

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