Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

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
Community Browser