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

Filter Date Range from Table script from Oracle DB

Good day!

I am quite new here on qlikview i've been exploring it for less than a week what i am trying to accomplish is to filter my table that grabs data from our database (Oracle). I've been researching for a while i can't seem to find a solution. I've already tried creating variables vStartDate and vEndDate. But i can't seem to reload the data once the user picked the dates. I am trying to do it with a button with Select in Field settings

Field: [TRAN_DT]

Search: '=ORIG_TRAN_DT>=vStartDate and ORIG_TRAN_DT<=vEndDate'

My vStartDate is = to a Calendar Obj and same goes for the vEndDate

I hope someone will be able to help me. I'm kind of a bit stuck for so many hours already.

Best Regards,

Hansel

0 Replies