Date Format

[sannidhikumar]

Hi All ,

how can i get date format  in calender object.

how can i achieve this .

thanks,

[tajmohamed30]

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

[kamal_sanguri]

try this

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

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

[sannidhikumar]

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 ,

[kamal_sanguri]

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')

[sannidhikumar]

Kamal ,

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

thanks ,

[sannidhikumar]

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 ,

[#8]

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

[kamal_sanguri]

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

[sannidhikumar]

kamal ,

thanks for the help .

thanks ,

pradeep

[kamal_sanguri]

No worries, happy that your issue is resolved.