Create a single date from an interval

[Martin-DWH]

Hello,

I hope that you can help me.

So basically I have a qvd with Date intervals like 4th August to 10th August, 11th August to 15th August and so on and on...

My goal is to create a datefield in which I can type a date and it should give me the correct interval. Do you know how to create such a visualization?

Thanks for your help!

[marcus_sommer]

You may look for the intervalmatch-feature or populating the dates with a simple loop-load, like:

t: load *, date(from + iterno() - 1) as Date from X while from + iterno() - 1 <= to;

[Martin-DWH]

Hello Marcus,

yeah, I thought this might would help. I have to tables basically:

Intervals:

Intervall:
LOAD
Date(FromDate),
Date(ToDate),
Account,
Sales
FROM [lib://QVD...

Calendar

Calendar:
LOAD
$(vBeginTime) + IterNo() - 1 AS Num,
Date($(vBeginTime) + IterNo() - 1) AS TempDate
AUTOGENERATE 1
WHILE $(vBeginTime) + IterNo() - 1 <= $(vEndTime);

VBegintime would be 1st January 2021

VEndTime is Today. 

But I don´t know how to link my Calendar to the intervals...

[marcus_sommer]

The direction of the logic between the tables is reverted. The date-population of the from/to to a dedicated date happens within the facts and not within the (normal) calendar.

This might be done in your case within the Intervall-table which creates an separate record for each date and measures like Sales are divided by (to - from + 1). In the most scenarios I would tend to such an approach and only if there are other specific requirements I would go for an another approach like keeping a liink-table after an IntervalMatch - Qlik Community - 1464547.