topic Re: Date Problem in QlikView

Date Problem

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

Hi Expertise please find the attachment of the QVW file ..

I have added a filter which has R_Load Date field .

If i try to sort it by descending it is not considering
and also i have tried to set the max date, by using the below expression with the text object

=Date(Max({1}[R_Load Date]),'M/D/YYYY')

=Date(Max(All [R_Load Date]),'M/D/YYYY')

But nothing is working

Need help on this

Thanks in Advance

Re: Date Problem

tresB — Thu, 06 Dec 2018 05:07:13 GMT

Your date field has text values, you need to convert it to date values using date#(). To resolve the problems at the source reload the date field like:

Date(Date#([R_Load Date], 'MM-DD-YYYY'), 'M/D/YYYY') as [R_Load Date]

Re: Date Problem

smilingjohn — Thu, 06 Dec 2018 05:26:26 GMT

Hi MVP

I made the suggested changes at the script and reloaded the application.

Date(Date#([R_Load Date], 'MM-DD-YYYY'), 'M/D/YYYY') as [R_Load Date]

after reloading i dont see any value in it ?

Re: Date Problem

tresB — Thu, 06 Dec 2018 05:39:04 GMT

That means, date values in your source is not in 'MM-DD-YYYY' format. What is your source? How doe date values look like there? Replace the date#() format with that one.

Re: Date Problem

smilingjohn — Thu, 06 Dec 2018 05:40:28 GMT

Hi MVM

Actaully the date at the DB itself is as shown in the below format .

date from source

and i have converted it to " date#(date(R_LOAD_DATE),'MM/DD/YYYY') as [R_Load Date]"

How do i deal with this ?

Re: Date Problem

tresB — Thu, 06 Dec 2018 05:52:12 GMT

So it's proper date values. And if you just want the date part (without time portion), you could load it like:
Load

Date(Floor(LOAD_DATE), 'M/D/YYYY')) as [R_Load Date]

Re: Date Problem

smilingjohn — Thu, 06 Dec 2018 06:16:36 GMT

Hi MVP ,

Thanks the date format conversion worked , but now i am not able to set the max date ,

i have added a text object and it is not considering the max date ,

Please find the attachment of the QVW file .

Thanks

Re: Date Problem

vipin_mishra479 — Thu, 06 Dec 2018 06:30:22 GMT

Try =Date(Max(Reload))in text box

Re: Date Problem

smilingjohn — Thu, 06 Dec 2018 06:33:25 GMT

I want to set this in actions .

when i land from another sheet then the date should set to max of reload date .

Re: Date Problem

vipin_mishra479 — Thu, 06 Dec 2018 06:41:50 GMT

I have attached the file please check

Re: Date Problem

smilingjohn — Thu, 06 Dec 2018 06:47:41 GMT

Hi Vipin,

My requirement is to display the max date within the filter not in a text object ,

Therefore i am using to write an expression within the trigger ( Action) so that when i click on the text object then the max reload date should get selected with the filter of converted date .

Thanks

Re: Date Problem

smilingjohn — Thu, 06 Dec 2018 07:09:03 GMT

Hi Vipin,

I want to set the max reload date within the Filter therefore i am trying to write the expression within the trigger of the text object so that when i click on it it should select the max reload date with the filter.

Thanks

Re: Date Problem

vipin_mishra479 — Thu, 06 Dec 2018 07:16:21 GMT

Sorry i am not get your point please correct me when you have select your max reload date in filter then why you need to pass this date on trigger .
Can you please elaborate this so that i can understand properly.

Re: Date Problem

vipin_mishra479 — Thu, 06 Dec 2018 07:19:08 GMT

Please check this is your requirement

Re: Date Problem

smilingjohn — Thu, 06 Dec 2018 07:20:47 GMT

Actually in an dashboard i will be displaying the reload date filter , where users can select different dates from the filter ,

and the data will be displayed accordingly .

I have a clear button displayed which is written within a text object when user click on the clear button the reload date to set to max value .

i hope you are clear now

Re: Date Problem

smilingjohn — Thu, 06 Dec 2018 08:38:20 GMT

Hi Vipin,

at first click it will set the values default to max of relaod ,
but when i select the other dates and click on the text object it will not set max reload again ?

Re: Date Problem

vipin_mishra479 — Thu, 06 Dec 2018 09:02:12 GMT

Can you try this