topic SAP - Select Option - How it works in Qlikview in QlikView

SAP - Select Option - How it works in Qlikview

Tue, 11 Nov 2014 03:19:41 GMT

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.

Re: SAP - Select Option - How it works in Qlikview

SergeyMak — Tue, 11 Nov 2014 03:23:46 GMT

Hi,

intervalmatch() in load script?

Regadrs,

Sergey

Re: SAP - Select Option - How it works in Qlikview

SergeyMak — Tue, 11 Nov 2014 03:39:33 GMT

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;

Re: SAP - Select Option - How it works in Qlikview

Tue, 11 Nov 2014 04:31:01 GMT

thanks for quick response Sergey Makushinsky

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