Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
SunainaUmberkar
Contributor III
Contributor III

Binding expressions in odag with range of date values

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.

 

Labels (1)
7 Replies
AnusuyaRajavel
Partner - Contributor
Partner - Contributor

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

SunainaUmberkar
Contributor III
Contributor III
Author

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
Partner - Contributor
Partner - Contributor

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

 

SunainaUmberkar
Contributor III
Contributor III
Author

Hello Anusuya,

The date field is stored as numeric. 

AnusuyaRajavel
Partner - Contributor
Partner - Contributor

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
Contributor III
Contributor III
Author

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

Freaz
Contributor
Contributor

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