topic Re: Mapping issue in QlikView

Mapping issue

Mon, 23 Nov 2015 03:31:48 GMT

Hi all,

I'm new to Qlikview, so was helping someone would point me in the right direction.

I'd like to Alias other fields using the Code field value.

So, when I select Name = 'NameA' then I want the table to show 'NameA' as Name and the other values (Names) returning the Code and not the Name.

Using this example if I select NameA, I'd like NameA and all the other codes to be shown- kind of like being masked, using the Code field vale...

I was thinking that we could use getfieldselections(Name) perhaps, but still haven't found a solution.

t_chetirbok — Mon, 23 Nov 2015 08:30:32 GMT

Hello!

You use a table object, try to use a chart with dimension "Name" and expression "only({1} Code)".

In that case your selections doesn't affect to chart

swuehl — Mon, 23 Nov 2015 10:56:55 GMT

Maybe using a calculated dimension like

=If(Name = GetFieldSelections(Name), Name, Code)

awhitfield — Mon, 23 Nov 2015 12:47:45 GMT

Do you mean like this?

Andy