topic Re: Range table in App Development

Range table

rulohx87 — Sat, 16 Nov 2024 21:10:30 GMT

Hello everyone,

I have the following range table.

This the Fact Table:

How do I get the credit number from the cost? I need the following table:

Thank you

Vegar — Tue, 26 Mar 2019 19:45:47 GMT

You should explore interval match.

Load * from RangeTable;
Load * from FactTable;
Intervalmatch (COST ) load Min,Max
from RangeTable;

Read more here: https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/LoadData/matching-intervals-to-discrete-data.htm

h_prakash — Tue, 26 Mar 2019 19:50:06 GMT

Hi,

Assuming Fact Table and Range Table is already loaded. try the below script.

RangeTable1:

IntervalMatch(Cost)

Load Min,

Max

Resident RangeTable;

Left Join(Fact Table)

Load "Time",

MinTimeStamp,

MaxTimeStamp,

Min&'-'&Max as MinMaxKey

Resident RangeTable1;

Drop Table RangeTable1;

Left Join(Fact Table)

Load Min&'-'&Max as MinMaxKey,

[# Credit]

Resident RangeTable;

Drop Table RangeTable;

Thanks

Prakash