topic Re: Date getting problem in QlikView

Date getting problem

Wed, 27 Jul 2011 13:36:56 GMT

Hi All,

Please see the attached file along with this post.

What i am trying to do is i want to get last 1 wek data into the listbox when i am selecting 1 week from inputbox but,i am not getting like that.

Can anyone help me in this?

Thanks.........

Date getting problem

Wed, 27 Jul 2011 14:06:41 GMT

Hello ravi,

this expression should work:

=if(Date > date($(vMaxDate)-$(vNDates)) , Date)

Regards, Roland

Re: Date getting problem

Wed, 27 Jul 2011 14:25:16 GMT

Hello Ronald,

Thanks for your reply

Please see the attached file

After changing my expression also it is not displaying last 1 week dates from the available dates.

Let me know where i was wrong.

Thanks........

Re: Date getting problem

rahulgupta — Wed, 27 Jul 2011 14:27:03 GMT

Hey Hi,

Its working fine.

Check out.

Regards

Re: Date getting problem

rahulgupta — Wed, 27 Jul 2011 14:33:03 GMT

Hi,

In the application you provided there is no dates for the last 1 week, thats why its not showing the values.

Now, in the attached Application i have generated dates and you can be able to see the required data.

Hope this helps.

Regards

Re: Date getting problem

Wed, 27 Jul 2011 14:39:32 GMT

Hi Rahul,

I am unable to open your file because i am using personel edition.

Last 1 week in the sense the data in the Date field Last 1 week data.

Please check my file ,It is not working .

Thanks.........

Re: Date getting problem

rahulgupta — Wed, 27 Jul 2011 14:56:22 GMT

Hi ravi,

its just because for the code you have written there is no no value in the date field.

you can check, your code works fine when you enter vNWeek = 6

As per my understanding, you want the date range even if it is not in your date Field. If this is the case, then you have to autogenerate the date seperately and have to link to your date field.

Use the following code to autogenerate:

LET MinYear = year(today())-2;
LET MaxYear = Year(today());
LET MonthMin = 1;
LET MonthMax = 12;

for Y = $(MinYear) to $(MaxYear)
for M = $(MonthMin) to $(MonthMax)
for D = 1 to 30

LedgerTemp:
LOAD
        $(Y) AS Year,
        $(M) AS Month,
        MakeDate($(Y),$(M),$(D)) as Date
AUTOGENERATE(1) ;
Next D
NEXT M
NEXT Y

Hope this solves your Issue.

If not understood, just copy and paste this code to your script pane and remove the current one. Then you can see what you want.

Regards

Re: Date getting problem

Wed, 27 Jul 2011 15:18:37 GMT

Hi Rahul,

Thanks , Now i got how the problem happens.

Now i have one doubt.

Please see the attached file.

Do like this

from the editscript

comment for step Two and go with One after that comment One and go with two.

I am creating one bookmark for the 1 weekdata(first it contains 3 days only).

After that i have inserted 2 more dates for that field.So with in the one week itself these dates also came.But when i am selecting the created bookmark,the new dates are not existed in that selections.I didn't get like that.

Is it possible to achieve like that?