Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

summe of one way and back way

Hi everyone. I have a round trip table, in which there is three colume"from" "to" "packets". I need to know between two punkt how many packets would be delivered. Sometime this is only one way between two cities.

this is the table,

fromtopackets
AB100
AC110
AD60
BA130
BD120
CA140

this is the results that I want to have,

BetweenPackets
A - B230 = (100+130 )
A - C250= (110 +140)
A - D60
B - D120

What is Dimension? How to write expression?

Thank you very much.

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

Re: summe of one way and back way

Try creating a new table in the script:

Input:

CrossTable(Destination,Value,2)

LOAD RowNo() as Row, packets, from, to INLINE [

    from, to, packets

    A, B, 100

    A, C, 110

    A, D, 60

    B, A, 130

    B, D, 120

    C, A, 140

];

Result:

LOAD Row, packets, concat(Value, ' - ') as List

Resident Input

Group By Row, packets;

Then use List as dimension and sum(packets) as expression.


talk is cheap, supply exceeds demand