Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Min and Max Date

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

5 Replies
Not applicable
Author

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

Not applicable
Author

But i want to select the end date

how do i do that ?

sushil353
Master II
Master II

Hi,

suppose EndDate field is coming from your calendar object..

Then calculate a variable

vEndDate = Max({1}EndDate)

HTH

Sushil

Not applicable
Author

I did not create any master calendar

kavita25
Partner - Specialist
Partner - Specialist

Hi,

Try this

Hope it helps you

Are you selecting the start date from calendar??

Regards,

Kavita