SAP - Select Option - How it works in Qlikview

[#1]

Hi guys..

any one ever create report 8A-PCA001G in SAP ?

in SAP, there is option select option which is we can select between values..

example :

TableA:

====================

ELNR1 | LOW | HIGH     | Text

====================

0001     | 10     |              | Sales A

0002     | 20     |              | Sales B

0003     | 10     | 40          | Total Sales

====================

TableB:

========================

AccountNumber | Sales | Budget

========================

10                     |  70     | 100

20                     |  80     | 150

30                     |  140   | 200

35                     |  30     | 300

40                     |  500   | 400

==========================

LOW & HIGH is Account Number.

what is the best way to work this out in qlikview ?

what i'm doing now is loop between low and high so i can get all possible account number.

but i can't make it work for total Sales..

Thanks in advance.

Aditya Christian.

[SergeyMak]

Hi,

intervalmatch() in load script?

Regadrs,

Sergey

[SergeyMak]

Hi,

Try this sollution

PFA

Data:
LOAD * Inline [
AccountNumber, Sales,Budget
10,70,100
20,80,150
30,140,200
35,30,300
40,500,400
];

[Report1]:
LOAD ELNR1,
LOW,
IF(HIGH='',LOW,HIGH) AS HIGH,
Text
  Inline [
ELNR1,LOW,HIGH,Text
0001,10,,Sales A
0002,20,,Sales B
0003,10,40,Total Sales
];


NoConcatenate
Report:
LOAD
ELNR1,
LOW,
HIGH,
Text,
LOW+IterNo()-1 as AccountNumber
Resident Report1
WHILE LOW+IterNo()-1<=HIGH;

DROP Table Report1;

[#4]

thanks for quick response Sergey Makushinsky

i'll try it first.. I'll let you know if it's works.