topic Re: Date Format in QlikView

Date Format

sannidhikumar — Mon, 29 May 2017 13:52:09 GMT

Hi All ,

how can i get date format in calender object.

how can i achieve this .

thanks,

Re: Date Format

RonaldDoes — Mon, 29 May 2017 14:10:53 GMT

Hi Pradeep,

Through the object properties -> Number -> Override Document Settings -> Date

Does that work for you?

With kind regards,

Ronald

Re: Date Format

sannidhikumar — Mon, 29 May 2017 14:18:18 GMT

Ronald ,

thanks for quick reply its not working i need batch date from to batch date to

as shown in pic.

any idea let me know .

thanks ,

pradeep

Re: Date Format

Anil_Babu_Samineni — Mon, 29 May 2017 14:20:14 GMT

Your question is not sufficient to reply, How is your date field looks like before move to the Date objects??

Re: Date Format

RonaldDoes — Mon, 29 May 2017 14:21:54 GMT

Hi Pradeep,

I'm not sure I understand your question entirely.

Do you want to adjust the formatting of the date? In that case just enter DD/MM/YYYY in the Format Pattern box in the Object Properties.

Re: Date Format

sannidhikumar — Mon, 29 May 2017 15:12:43 GMT

Ronald ,

formate i made i just want to get that format from to To.

as it shown,

thanks,

Re: Date Format

vishsaggi — Mon, 29 May 2017 15:19:21 GMT

What format you are seeing your calendar object? The one you posted initially the snapshot is that not you can see? If not what exactly you want to see in those objects?

Re: Date Format

tajmohamed30 — Mon, 29 May 2017 18:00:19 GMT

to change the calender objecter format you can change the format of date in script and bring that field in from and to date calender object

Re: Date Format

its_anandrjs — Mon, 29 May 2017 18:51:57 GMT

Can you please attached sample data.

Regards,

Anand

Re: Date Format

sannidhikumar — Tue, 30 May 2017 05:06:23 GMT

Mohammad ,

Already i tried back end but when i changing in from and to using min and max

=date(date#(min(BatchDate2),'YYYYDDMM'),'DD/MM/YYYY')

=date(date#(max(BatchDate2),'YYYYDDMM'),'DD/MM/YYYY')

but it showing this way.

Re: Date Format

tajmohamed30 — Tue, 30 May 2017 09:26:15 GMT

have you checked the properties Number tab>tick override document settings>Select Date and check format pattern and give ok

Re: Date Format

kamal_sanguri — Tue, 30 May 2017 09:47:21 GMT

try this

=date(date#(date(min(BatchDate2),'YYYYDDMM'),'YYYYDDMM'),'DD/MM/YYYY')

=date(date#(date(max(BatchDate2),'YYYYDDMM'),'YYYYDDMM'),'DD/MM/YYYY')

Re: Date Format

sannidhikumar — Tue, 30 May 2017 09:59:21 GMT

HI,

thanks for reply Taj and Kamal i used this format

=date(min(BatchDate2),'DD/MM/YYYY')

=date(max(BatchDate2),'DD/MM/YYYY')

i got the format this way . and in the table it is not changing when dates changing any idea on this let me know ,

Re: Date Format

kamal_sanguri — Tue, 30 May 2017 10:04:15 GMT

because you have specifically asked Qlikview to format date inside the date picker only, you have to do same for the dates in table.

so, something like

Date(Date#(DateField,'DD-MM-YYYY'),'DD/MM/YYYY')

Re: Date Format

sannidhikumar — Tue, 30 May 2017 10:35:55 GMT

Kamal ,

i got what u said but below table should show as per date selection how can i make it any expression .

thanks ,

Re: Date Format

sannidhikumar — Tue, 30 May 2017 10:40:40 GMT

kamal ,

expression is =SUM(AMOUNT_USD)/FX_CONV_RT/metric

dimentions are Explannation and batchdate2

how can i make the expression to run as per selection dates.

thanks ,

Re: Date Format

Tue, 30 May 2017 12:05:03 GMT

Could you try changing it to web view and see if it works afterwards?

Re: Date Format

kamal_sanguri — Tue, 30 May 2017 12:07:11 GMT

sum({$<BatchDate2={">=StartDate<=Enddate"}>AMOUNT_USD)/FX_CONV_RT/metric

EDIT

Start date and End Date would be the dates from your calendar control. You can save those two dates in variable and can use in place of StartDate and EndDate

Re: Date Format

sannidhikumar — Tue, 30 May 2017 12:38:46 GMT

kamal ,

thanks for the help .

thanks ,

pradeep

Re: Date Format

kamal_sanguri — Tue, 30 May 2017 13:12:46 GMT

No worries, happy that your issue is resolved.