topic Re: script in QlikView

script

Thu, 03 Apr 2014 14:14:00 GMT

Hi all,

I got the data of loadplace/area/country and the place of unloadplace/area/country in my script:

Revenue.LoadPlace

AS LoadPlace,

Revenue.UnloadPlace

AS UnloadPlace,

now I want a dimension that shows me these 2 behind each other like:

Arnhem - Amsterdam

How to achieve this and it's probably the basics but I tried alot and just can't remember how to solve the issue.

kind regards

its_anandrjs — Thu, 03 Apr 2014 14:17:20 GMT

As i under stand create another field in the load script

Revenue.LoadPlace AS LoadPlace,

Revenue.UnloadPlace AS UnloadPlace,

Revenue.LoadPlace &'-'& Revenue.UnloadPlace as Newfield //Add new field

New Update:- Without adding that field in the Load statement you are do this in Dimension also like

Eg:- Revenue.LoadPlace &'-'& Revenue.UnloadPlace

Ferran_Garcia_Pagans — Thu, 03 Apr 2014 14:17:31 GMT

Hi Vicent,

Revenue.LoadPlace&' - '&Revenue.LoadUnplace as NewField,

Regards, Ferran.

srchilukoori — Thu, 03 Apr 2014 14:18:45 GMT

if you are trying to create a simple calculated dimension, you can use

LoadPlace&' - '&UnloadPlace

in the dimensions.

alexandros17 — Thu, 03 Apr 2014 14:20:23 GMT

Try with a edited dimension something like:

LoadPlace & ' - ' & UnloadPlace

as your new dimension

Thu, 03 Apr 2014 14:25:27 GMT

Hi Vincent,

Use calculated Dimension.

in that add LoadPlace &'-'& UnloadPlace.

Thank you.