topic Re: Date selection- from and to date in QlikView

Date selection- from and to date

Thu, 29 Jan 2015 11:39:05 GMT

Hi All,

I have a date column TransDate.

How can I created FromDate and Todate from TransDate?

Thanks in advance.

Re: Date selection- from and to date

arulsettu — Thu, 29 Jan 2015 11:45:04 GMT

try this

FromDate = min(TransDate)

Todate = max(TransDate)

Re: Date selection- from and to date

Anonymous — Thu, 29 Jan 2015 11:56:42 GMT

You need to load two more data island columns in your script other wise once you will do selection in TransDate it assign same value in FromDate and ToDate.

so do a resident load from the table where TransDate column is loaded

load

distinct (TransDate) as FromDate

resident table(abc);

Load

distinct (TransDate) as ToDate

resident table(abc);

Then use these fields for selection (calender/Slider) and store the value into variables

and use those variables in your expression.

Hope this help!!

Re: Date selection- from and to date

jagan — Thu, 29 Jan 2015 13:24:42 GMT

Hi,

Please find attached file for solution.

Regards,

Jagan.