Select a date or use input field

[#1]

Hello, in order to sort my datas, I'm using different selection lists with the years, the months and the weeks. Moreover, I would like to use two input field where the user can determine himslef the period of calculations.

Therefore, I would like that when the user select, let say, a week in the selection list, that the two variables of the input fields adapt themselves to the new selection with min and max values. How could I proceed?

Thanks!

[#2]

Here are the files, I will check what I did wrong, and I find how, I'll let you know

[ashfaq_haseeb]

Cannot download.

Its corrupted.

Regards

ASHFAQ

[#4]

Oh that's strange. Maybe with this one

[jpenuliar]

Hi,

Have a look at this already answered similar situation.

Start End Dates using calendar object

[jpenuliar]

or this one:

http://www.learnqlickview.com/dynamic-calendar-widget-in-qlikview/

[#7]

Well I don't undertstand 😕 I did exactly the same as in the videos and it stille doesn't work

All my dates are in a format DD/MM/YYYY in the field "JD_DATE" and my two variables are called:

- vDateDebMiseProd (start)

- vDateFinMiseProd (end)

I added those triggers:

Field: "JD_DATE"

Search string:   ='>=' & vDateDebMiseProd & '<=' & vDateFinMiseProd

I don't know why it doesn't want to work. In order to see if it worked, I used a single table with the fiels JD_DATE so all the dates are shown but it doesn't change when changing the variables.

Do you think it can come from the script? I'm actually using the master calendar in it so in my selection list, I'm using these fields:

week(TempDate) As JD_Week

Year(TempDate) As JD_Year

Month(TempDate) As JD_Month

Day(TempDate) As JD_Day

When I select, let say a week, it works perfectly, but with the variables, not

[jpenuliar]

Hi,

See if your variable values are same format DD/MM/YYYY.

I usually have the key field in my calendar Numeric and my variables numeric.

both have to be same format

[#9]

In my script, I have: both SET DateFormat='DD/MM/YYYY' and  date(ENDV_DATE, 'DD/MM/YYYY') as JD_DATE and my variables are set as dates DD/MM/YYYY in their properties

[ashfaq_haseeb]

I still cannot open this files.

Regards

ASHFAQ

[jpenuliar · Accepted solution]

attached sample file using your  qvd data.

I built from scratch as your app Data model is full of synth keys.

Please note of the variables and trigger associated.

Hope this helps.

JP