topic Re: Min and Max Date in QlikView

Min and Max Date

Wed, 14 Jan 2015 07:43:52 GMT

Hi i have a table Called trx_date date related to particular product .

I had created to variable s to get the start date and end date .

start date=Date(aggr(min(trx_date), Product)))

End date=Date(aggr(Max(trx_date), Product)))

And the above variables are working fine , But i want to select the end date in a calender which i am not able to do . i can only see the values of the product starting date and ending date .

I want to select the end date manually in the calendar for particular product , Can some one help me plz

Re: Min and Max Date

Wed, 14 Jan 2015 07:45:17 GMT

take that start date in to inputbox and enter which date u want

Re: Min and Max Date

Wed, 14 Jan 2015 07:50:14 GMT

But i want to select the end date

how do i do that ?

Re: Min and Max Date

sushil353 — Wed, 14 Jan 2015 07:53:17 GMT

Hi,

suppose EndDate field is coming from your calendar object..

Then calculate a variable

vEndDate = Max({1}EndDate)

HTH

Sushil

Re: Min and Max Date

Wed, 14 Jan 2015 07:55:04 GMT

I did not create any master calendar

Re: Min and Max Date

kavita25 — Wed, 14 Jan 2015 11:12:57 GMT

Hi,

Try this

Hope it helps you

Are you selecting the start date from calendar??

Regards,

Kavita