topic Re: Apply Map for multiple values in QlikView

Apply Map for multiple values

Mon, 03 Nov 2014 13:07:56 GMT

Hi Friends

I have two fieds and thier descriptions.

X Desc and Y Desc

1 HHH 9 AAA

2 PPP 8 BBB

3 JJJ 7 CCC

And their combination gives different description like this

X Y Desc

1 9 SSS

2 9 EEE

3 8 RRR

Now I want to display these descriptions when the user mouse over the cells.

The problem is the combination of these values. How to handle this situation.

Thanks

Re: Apply Map for multiple values

MK_QSL — Mon, 03 Nov 2014 13:11:31 GMT

Can't understand your question properly? Can you provide more information pls?

You can use

MapTemp:

Mapping Load

X&Y as Key,

Desc

From TableName;

Now use

ApplyMap('MapTemp',X&Y,'Unknown') as Desc

Re: Apply Map for multiple values

JonnyPoole — Mon, 03 Nov 2014 18:44:53 GMT

Straight Tables and Pivot Tables do not support tooltips / popups on the cell , just the field header... so whether its the first , second or combination description field this isn't possible.

You could do that in a visual chart however or just add a 2nd expression to the chart and give users the toggle to show one , none or both expressions