topic Re: IF statement with IF conditions? in QlikView

IF statement with IF conditions?

Wed, 07 Jan 2015 16:48:01 GMT

I made it to complicated. So let me try this:

If(MONTH(Today(1)) = 'Jan', 
        IF(Year(OrderingPrescriber_RevenueDate) = (Year(Yearstart( Today( ) ))-2)
            ,Year(Today(1))-2
            ,Year(Today(1))-1)
        ,
        IF(Year(OrderingPrescriber_RevenueDate) = (Year(Yearstart( Today( ) ))-1)
            ,'STLY'
            ,'YTD'))

So if the current month is Jan I want to have it display 2013 and 2014 but if the current month is not Jan, we will consider it the current years data and we want it to display STLY and YTD.

Re: IF statement with IF conditions?

Peter_Cammaert — Wed, 07 Jan 2015 18:03:38 GMT

Shouldn't the second IF test be something like this (pseudo code) ?:

IF ((Year(OrderDate) = Year(Today()) -1) and (Month(OrderDate) = 12), 1, 0) , ...

Re: IF statement with IF conditions?

cspencer3 — Wed, 07 Jan 2015 19:05:33 GMT

I am a little bit confused on exactly what you are doing, but you can also use the InYearToDate() function as well to determine if a date is In the year to date. If you pass the function a -1, it will tell you if the date was in Last year's year to date (using the current date). I am not sure if that will help you but wanted to throw it out there.

Re: IF statement with IF conditions?

Colin-Albert — Wed, 07 Jan 2015 19:18:26 GMT

This post might help with calculating YTD

http://community.qlik.com/message/469066

Re: IF statement with IF conditions?

Wed, 07 Jan 2015 20:43:42 GMT

I made it a bit complicated to understand. I redid the original post. Could you please take a look?