topic Re: Is it possible to Concat two field within intervalmatch() function..? in QlikView

Is it possible to Concat two field within intervalmatch() function..?

sgg_gaikwad — Thu, 13 Feb 2014 09:29:50 GMT

IntervalMatch:

IntervalMatch(Date)

LOAD

[GL Account Start] & [GL Account End] Resident Layout;

OUtput: I want only two field in IntervalMatch table....

Re: Is it possible to Concat two field within intervalmatch() function..?

Thu, 13 Feb 2014 09:32:22 GMT

try according to this

IntervalMatch:

IntervalMatch(Date)

LOAD

[GL Account Start] , [GL Account End] Resident Layout;

Re: Is it possible to Concat two field within intervalmatch() function..?

sgg_gaikwad — Thu, 13 Feb 2014 09:35:27 GMT

Hi Vishwaranjan,

I did the same thing but i want only TWO field in INTervalMatch table....?

Re: Is it possible to Concat two field within intervalmatch() function..?

Thu, 13 Feb 2014 09:42:15 GMT

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;

Re: Is it possible to Concat two field within intervalmatch() function..?

hic — Thu, 13 Feb 2014 09:45:46 GMT

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

Re: Is it possible to Concat two field within intervalmatch() function..?

er_mohit — Thu, 13 Feb 2014 10:05:24 GMT

See the attached file for interval match