topic Variable not working. in QlikView

Variable not working.

Thu, 10 Oct 2013 11:55:05 GMT

hi,

i have created two variable for startdate=min({$}Date) and enddate=max({$}Date). but every time i open qvw both the variable changes into number format like '54621' likewise. please help.

Re: Variable not working.

mdmukramali — Thu, 10 Oct 2013 11:59:55 GMT

Dear Piyush,

Try to create startdate=min(Date) and

enddate=max(Date).

check whether the Date is in number format or in date.

if it is in number format then

startdate=Date(min(Date))

enddate=Date(max(Date))

Thanks,

Mukram.

Re: Variable not working.

fdelacal — Thu, 10 Oct 2013 12:00:33 GMT

you should put the format.

date(yourfield,'YYYY/MM/DD')

startdate=date(MIN(yourfield),'YYYY/MM/DD')

enddate=date(MAX(yourfield),'YYYY/MM/DD')

HOPE THAT HELPS

Re: Variable not working.

Thu, 10 Oct 2013 12:05:00 GMT

you need to set date format..

Go to Settings ---> Document Properties --> Number --> Select "Variables" on drop down.

Then you can set format for your variable..

Karthik

Re: Variable not working.

saumyashah90 — Thu, 10 Oct 2013 12:11:30 GMT

Hi Piyush what you try is

startdate=Date(min({$}Date),'DD-MM-YYYY')

enddate=Date(max({$}Date),'DD-MM-YYYY')