Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
IntervalMatch:
IntervalMatch(Date)
LOAD
[GL Account Start] & [GL Account End] Resident Layout;
OUtput: I want only two field in IntervalMatch table....
hi
try according to this
IntervalMatch:
IntervalMatch(Date)
LOAD
[GL Account Start] , [GL Account End] Resident Layout;
Hi Vishwaranjan,
I did the same thing but i want only TWO field in INTervalMatch table....?
hi
try this example
Key:
LOAD * INLINE [
Persons in Household/IncomeStart/IncomeEnd/IntervalName
1/24000/30000/<30%
1/30001/40000/31-40%
1/40001/50000/41-50%
2/25000/31000/<30%
2/31001/41000/31-40%
2/41001/51000/41-50%
] (delimiter is '/');
Population:
LOAD * INLINE [
Persons in Household/IncomeLevel
1/24020
2/45000
1/45500
4/35000
] (delimiter is '/');
IntervalMatch (IncomeLevel,[Persons in Household]) LOAD IncomeStart, IncomeEnd, [Persons in Household] Resident Key;
You cannot do it in one pass. However, if you let the IntervalMatch prefix generate a temporary table, from which you in a second step create what you want, then it is doable. I do exactly this when I solve problems around Slowly changing dimensions.
See more on
http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/03/slowly-changing-dimensions
IntervalMatch and Slowly Changing Dimensions
HIC
See the attached file for interval match