topic Re: Mapping data in QlikView

Mapping data

Anonymous — Fri, 09 May 2014 15:56:19 GMT

Hi guys,

I have file with 2 variables Channel and Campaign with orderID.

I want to apply map for orderID to recode them to rgb color.

It works for only one variable.

Could you help me to understand why?

Please see my files.

Thanks,

Jason_Michaelides — Fri, 09 May 2014 16:14:50 GMT

What do you mean "It works for only one variable"? Looks like it is working in your application?

Anonymous — Fri, 09 May 2014 16:18:53 GMT

it works for channel field, but if I select campaign, it doesn't show multicolor

maxgro — Fri, 09 May 2014 18:02:27 GMT

perhaps because the field orderID1 you use to map the color is not filled for Channel?

so you get 192, ...., ligthgray()

Anonymous — Fri, 09 May 2014 18:19:41 GMT

it works only with this condition

If(Fields='Campaign', orderIDColor,

If(Fields='Channel', orderIDColor1))

Could I modify or simple it to have only one variable orderIDColor?

Each channel has own number and each campaign has own number

I want, when I select channel or campaign, it shows own color.

Thanks,

maxgro — Fri, 09 May 2014 19:13:33 GMT

do you mean 1 field orderidcolor?

in your model you have some row with 2 orderid (orderid1 and orderid2), and 2 colors, so you need 2 fields

to have only 1 field for color I suppose you must use a single field instead of 2 for Channel and Campaign,

1 field for color

1 added field for type (Channel or Campaign)

I do not know if it makes sense in your case

Anonymous — Fri, 09 May 2014 19:28:18 GMT

Whe I run load ,

I get a message

maxgro — Fri, 09 May 2014 19:53:13 GMT

drop the 2 tables NumberID and NumberID1 at the end

they have the same fields Red Green Blue and they create a loop in the model

in online help, search circular references for a detailed explanation