topic Re: Displaying the last loaded month data in QlikView

Displaying the last loaded month data

Wed, 03 Apr 2013 13:49:08 GMT

Hi,

We wanted to show monthwise data of the current stock of products.When we select the specific month, it should display the current stock available for that month. Suppose for this year, I have the current stock data available from jan to March, Is there any method that when I select april or May or even December, it should display me the last loaded month data ie here its should be march. Can someone help please!!!

Re: Displaying the last loaded month data

Thu, 12 Sep 2013 12:40:58 GMT

Found a solution yet?

I have done something similare to that

Re: Displaying the last loaded month data

Thu, 12 Sep 2013 12:44:25 GMT

Yes! You could just make ur expression like Max(Month(Today()-1)), Then when selecting a max mont eg. May, it would so april.. Selecting April it would show March and so on.

or Month(Addmonths(Today(),-1))

Re: Displaying the last loaded month data

Anonymous — Thu, 12 Sep 2013 12:58:59 GMT

expression

=count({<

year=,

month=,

quarter=,

monthyear=,

dateNum=

{'>=$(=(Num(MonthStart(vSelectedDate, -2))))<=$(=(Floor(MonthEnd(vSelectedDate))))'}>} [Order id])

and

create one variable -> vSelectedDate = =If(Num(MonthEnd(Makedate(Max(year), Max(month), 1))) > Num(Today()), Num(Today()), Num(MonthEnd(Makedate(Max(year), Max(month), 1))))

try this

Regards

Ashok