topic Re: Resolve Synthetic key in interval match in QlikView

Resolve Synthetic key in interval match

Anonymous — Thu, 09 Jun 2016 09:32:15 GMT

Hi All,

I have aggregated count per request what i want is to create range as per the count

Expected Output:

Request Count Range

1 104 101-200

2 207 201-300

3 304 301-400

4 403 401-500

I can achieve this with interval match but with a synthetic key .

I wish to get rid of this synthetic key

Please find the attached file .

Thanks,

Nishant N

Re: Resolve Synthetic key in interval match

prasadcm — Thu, 09 Jun 2016 10:23:59 GMT

Hi,

This might help

Interval Match or Inline load

Regards,

Prasad

Re: Resolve Synthetic key in interval match

sunny_talwar — Thu, 09 Jun 2016 10:34:17 GMT

Not sure why you want to get rid of the synthetic key here. If you read HIC's blog here -> IntervalMatch, you would see that this synthetic is not a bad thing to have here

If you still think you need to remove it, you can join the IntervalMatch table to one of your tables above to combine the tables into one.

Re: Resolve Synthetic key in interval match

sasiparupudi1 — Thu, 09 Jun 2016 10:36:13 GMT

Range:

load * inline

[

Count_Min ,Count_Max,Range

101,200, 101-200

201,300, 201-300

301,400,301-400

401,500,401-500

501,600,501-600

];

ScoreDetails:

load * inline

[

Count , Request

107, 1

207, 2

307, 3

406, 4

307,5

];

left join(ScoreDetails)

IntervalMatch(Count) load

Count_Min ,Count_Max

Resident Range;

drop Table Range;

Re: Resolve Synthetic key in interval match

sunny_talwar — Thu, 09 Jun 2016 10:41:00 GMT

Another option:

Range:

LOAD Count_Min + IterNo() - 1 as Count,

While Count_Min + IterNo() - 1 <= Count_Max;

LOAD* Inline [

Count_Min ,Count_Max,Range

101,200, 101-200

201,300, 201-300

301,400,301-400

401,500,401-500

501,600,501-600

];

ScoreDetails:

Right Keep (Range)

LOAD * Inline [

Count , Request

107, 1

207, 2

307, 3

406, 4

307,5

];

Re: Resolve Synthetic key in interval match

qlikview979 — Thu, 09 Jun 2016 10:49:17 GMT

Hi,

Please edit your script and write this"Drop Table Range; "

Range:

load * inline

[

Count_Min ,Count_Max,Range

101,200, 101-200

201,300, 201-300

301,400,301-400

401,500,401-500

501,600,501-600

];

ScoreDetails:

load * inline

[

Count , Request

107, 1

207, 2

307, 3

406, 4

307,5

];

IntervalMatch(Count) load

Count_Min ,Count_Max

Resident Range;

Drop Table Range;

Re: Resolve Synthetic key in interval match

jim_chan — Tue, 30 Aug 2016 04:03:06 GMT

if i drop the table Range. i wouldnt be able to use the Range Field.

What if i want to use the Range field as well?\

Rgds

Jim

Re: Resolve Synthetic key in interval match

Anonymous — Tue, 30 Aug 2016 06:47:46 GMT

Exactly Jim, I need to use Range field as a dimension

Thanks and Regards,

Nishant Nadkarni