topic Re: IF statement in QlikView

IF statement

ajsjoshua — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I am facing problem with the If statement

suggest me some ideas

if(

Max(Week_Up)<=8,

Sum({< Year_UP ={$(=Max(Year_UP)-1)}, Week_UP = {"52 - (8 - Max(Week_Up)"} >}Orders),

sum({<Year_UP = {$(=Max(Year_UP))},Week_UP = { $(=Max(Week_UP)-8) },Week = {"=$(=Max(Week_UP))"}>}Orders)

)

Re: IF statement

PrashantSangle — Thu, 23 Jun 2016 06:09:49 GMT

Hi,

can you tell your issue in details

in above expression you can try below

Week_UP = {"$(=52 - (8 - Max(Week_Up))"}

Regards

Re: IF statement

ajsjoshua — Thu, 23 Jun 2016 06:17:02 GMT

Hi dreamer4

Whenever Max(Week_Up) will be less than 8 it become -ve.

Re: IF statement

susovan — Thu, 23 Jun 2016 06:25:50 GMT

Hi joshua,

Try this expression,

if(

Max(Week_Up)<=8,

Sum({< Year_UP ={"$(=Max(Year_UP)-1)"}, Week_UP = {"52 - (8 - Max(Week_Up)"} >}Orders),

sum({<Year_UP = {"$(=Max(Year_UP))"},Week_UP = { "$(=Max(Week_UP)-8)"},Week = {"=$(=Max(Week_UP))"}>}Orders)

)

Re: IF statement

ajsjoshua — Thu, 23 Jun 2016 06:27:52 GMT

Hi Susovan Ghosh,

Its not working.

Re: IF statement

PrashantSangle — Thu, 23 Jun 2016 06:33:03 GMT

Hi,

In your set analysis expression

52 - (8 - Max(Week_Up) this will treat as string , It will not return any value.

For that you have to modify it like

{"$(=52 - (8 - Max(Week_Up)))"}

Note : You have also missing ) bracket.

Regards

Re: IF statement

susovan — Thu, 23 Jun 2016 06:39:53 GMT

Try this,

if(

Max(Week_Up)<=8,

Sum({< Year_UP ={">=$(=Max(Year_UP)-1)"}, Week_UP = {">=$(vWeek)"} >}Orders),

sum({<Year_UP = {">=$(=Max(Year_UP))"},Week_UP = { ">=$(=Max(Week_UP)-8)"},Week = {">=$(=Max(Week_UP))"}>}Orders)

)

Here vWeek="=52 - (8 - Max(Week_Up))"

Re: IF statement

ajsjoshua — Thu, 23 Jun 2016 07:00:44 GMT

Hi Susovan Ghosh

Its taking entire week_Up bro,

Re: IF statement

susovan — Thu, 23 Jun 2016 07:29:30 GMT

Can you tell me what is the actual output?