topic Interval match DB in QlikView

Interval match DB

Prabhu1204 — Sat, 16 Nov 2024 00:59:32 GMT

Hello,\

I have the below table holds the field

class_date_key from fact table

Class_Date ,date_key from Dates table

CLASS-description,
class_strat_date,
class_end_date from class table

I need to create to qvd to get correct class description,
using the date key from fact table , fetching class-dates values by giving condition where Fact.class_date_key = date.date_key.

But when i select the date for class date ,the dates are not fallen between class start and class end..

-For ex : if I select Class date as ' 07-JAN-20' , getting both the below

class start date class end date

01-JAN-20 01-JAN-30
07-JAN-20 01-JAN-30

I should only get the 7-jan-20 and not the 01-jan-20.

how to use interval match here ( direct from db and store as qvd)

Re: Interval match DB

jonathandienst — Tue, 24 Mar 2020 07:27:22 GMT

That's how intervalmatch works - it will match more than one value if the ranges overlap. What rule are you using to select which interval to use?

Re: Interval match DB

Prabhu1204 — Tue, 24 Mar 2020 07:34:34 GMT

No, I dint use interval match. As now i fetched all the required fields from table. Not use how to use interval match while db fetching.

my code is like below ;

select class_date,
class_description,
class_start_date,
class_end_date
From
class_description,
Dates,
fact_table
where dates.date_key = fact_table.class_date_key;( To take class date, linking the fact table to the date table)

I am not sure whether i am wrong