topic Re: Nested if then esle statement in QlikView

Nested if then esle statement

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have two if statements as shown below. The first works out the revenue target value for the current month to date if the day is not the first of the month and the seconds works out the values for the previous month (the dimension is customer. My problem is that I don't know how to put this in one statement as it errors. Maybe I'm not doing the best way and help would be greatly appreciated

=if (day(today())>1,
sum({$<MonthID = {$(=Max(MonthID))},
Quarter = ,
[LinkId] = {"TMP"},
Month ={$(=month(today()))},
Year ={$(=year(today()))}
>} [Revenue Target Value]))
---------------
=if (day(today())=1,
sum({$<MonthID = {$(=Max(MonthID))},
Quarter = ,
[LinkId] = {"TMP"},
Month ={$(=month(Addmonths(Today(), -1)))},
Year ={$(=year(today()))}

>} [Revenue Target Value])

Re: Nested if then esle statement

sunny_talwar — Fri, 26 Aug 2016 12:40:51 GMT

May be like this:

=If(Day(Today()) > 1,
Sum({$<MonthID = {$(=Max(MonthID))}, Quarter = , [LinkId] = {"TMP"}, Month ={$(=month(today()))}, Year ={$(=year(today()))}>} [Revenue Target Value])),

Sum({$<MonthID = {$(=Max(MonthID))}, Quarter = , [LinkId] = {"TMP"}, Month ={$(=month(Addmonths(Today(), -1)))}, Year ={$(=year(today()))}>} [Revenue Target Value]))

Re: Nested if then esle statement

Fri, 26 Aug 2016 12:56:52 GMT

Wow, how quick did you reply!!!

You put an extra bracket on the end. I took that off and got garbage after expression:"'," error

after the first if statement none of the restricted are highlighted in the second expression

Any idea

Re: Nested if then esle statement

sunny_talwar — Fri, 26 Aug 2016 13:00:15 GMT

Right, so this isn't working? (Removed the parenthesis after the end of first Sum function)

=If(Day(Today()) > 1,
Sum({$<MonthID = {$(=Max(MonthID))}, Quarter = , [LinkId] = {"TMP"}, Month ={$(=month(today()))}, Year ={$(=year(today()))}>} [Revenue Target Value]),

Sum({$<MonthID = {$(=Max(MonthID))}, Quarter = , [LinkId] = {"TMP"}, Month ={$(=month(Addmonths(Today(), -1)))}, Year ={$(=year(today()))}>} [Revenue Target Value]))

Re: Nested if then esle statement

Fri, 26 Aug 2016 13:08:16 GMT

perfect thanks so much. You're a diamond., are you on linkedin?

Re: Nested if then esle statement

sunny_talwar — Fri, 26 Aug 2016 13:08:47 GMT

I sure am

Re: Nested if then esle statement

Fri, 26 Aug 2016 13:11:32 GMT

what's your last name

Re: Nested if then esle statement

sunny_talwar — Fri, 26 Aug 2016 13:15:16 GMT

Its Talwar