Binding expressions in odag with range of date values

[SunainaUmberkar]

Hello All,

I have a requirement where I need to use ODAG for passing a range of date values . 

I need to pass an Start date and End date using odag binding expressions in the template app. 

I tried using

Load * from qvd 

Where date>=$(odag_startdate) and date <=$(odag_enddate);

And I have defined the odag variable as 

Set odag_startdate=' ' ' 12411' ' ';

Set odag_enddate=' ' ' 12430' ' ';

But these odag variables are not working on the above where conditions. 

Kindly help as how can I pass date range using odag variables.

Thank you in advance.

[AnusuyaRajavel]

Hello @SunainaUmberkar 
Have you checked Your date field format type?

[SunainaUmberkar]

Hello Anusuya,

Yes I have checked the date field format. The format of date is in '1YYMM'. We normally assign 1 with all the dates hence I have given the same format. Is there issue with the date format?

[AnusuyaRajavel]

Check whether the date field in your qvd is stored as numeric or string?

[SunainaUmberkar]

Hello Anusuya,

The date field is stored as numeric. 

[AnusuyaRajavel]

I tested the expression, and it appears to be working fine on my end with the numeric date format. Just try without quotes in ODAG variables

[SunainaUmberkar]

Sure. Thank you for your response. I will try checking.

[Freaz]

Hello all,

Can somebody help me on the same issues? I think it's similar issues; mine :- 

User would select a Contract Account and generate the apps (ODAG them) - this is doable

However, user request if they can also make date selection themselves (1st January 2025 until 31st March 2025) and able to ODAG for specific user on specific date.

I tried using Variables but it doesnt work; perhaps i did it wrong or Qlik dont have this function yet. Can somebody guide me on the right path?

Freaz