topic Urgent! Bi-Direction in QlikView

Urgent! Bi-Direction

n1ef5ng1 — Wed, 17 Jul 2013 05:40:18 GMT

Hi Gurus,

See attached file below in QV,

I have this fields call Country_ID, Country_From and Country_To,

'List' table just show the value of Country_From and Country_To

If CN to ID is 30 box and ID to CN is 140 box, it will display 170 on the second table. This refers to table name call Bi Direction Between Country_From and Country_To.

Desired Table - Bi Direction

Now my problem is, when user select Country call Indonesia, it will have this //Code Here column where it will display the countries with bi direction value.

Basically is like Indonesia to any other countries with bi direction.

(Unable to do this on edit script)

I not sure if aggr will solve, if do please help.

Thanks! being stuch this problem for months

Re: Urgent! Bi-Direction

n1ef5ng1 — Wed, 17 Jul 2013 06:02:03 GMT

Desired table expected value

BB - 50

BK - 15

CN - 170

DE - 80

DW - 34

FE - 48

ID-ID - 0

TK - 60

Re: Urgent! Bi-Direction

luciancotea — Wed, 17 Jul 2013 06:49:20 GMT

Code here: =replace(COUNTRY_FROM & COUNTRY_TO, COUNTRY_ID, '')

Re: Urgent! Bi-Direction

n1ef5ng1 — Wed, 17 Jul 2013 07:17:00 GMT

ur example is correct, but it doesn apply to my report.

I realized there is no way to have ID to ID right?

Re: Urgent! Bi-Direction

luciancotea — Wed, 17 Jul 2013 07:20:00 GMT

Right. Without touching the script, can't do much.