Discussion Board for collaboration on QlikView Scripting.
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
May I ask why you dont want intervalmatch?
I believe is the easiest way
i have many dates... so creation of tat many interval match is fine...??? will tat affect performance ???
can i get solution if so??
Here is a quick solution though it creates synthetic keys