Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

creation of master calendar and comparing interval dates -

Hi all

i have Sales order, eng ind date, module ind date, dispatch date etc in fact table. Sales order is unique key

i have calendar. AP start date.,, year, end date.

now i need to say.. how many eng inducted in an particular AP based on eng ind date

similarly for all the fields... is there any way... no interval match pls...

pl reply sooner

Tags (1)
3 Replies
Not applicable

creation of master calendar and comparing interval dates -

May I ask why you dont want intervalmatch?

I believe is the easiest way

Not applicable

creation of master calendar and comparing interval dates -

i have many dates... so creation of tat many interval match is fine...??? will tat affect performance ???

can i get solution if so??

Not applicable

Re: creation of master calendar and comparing interval dates -

Here is a quick solution though it creates synthetic keys