4 Replies Latest reply on Jun 8, 2016 3:25 AM by Jan Paulsen

Tooltip not working - ATTR seems to be the issue

Jan Paulsen Jun 5, 2016 10:21 AM

Hi board members,

I have the following data:

I want to show the values for each country in a tooltip:

This works fine for Germany, I simply created a pill (If Country = 'Germany' then Value) and dragged it to the tooltips chart. For France it does not work that way as there are two rows in the data. I used the following syntax (otherwise I am told that I cannot use aggregate and non-aggregate measures in an if statement): If ATTR([Country]) = 'France' THEN SUM([Value]) END.

However, I get a blank. Can anyone make this work? Dragging country to the details shelf (and thereby splitting the graph) is not a solution:). Furthermore: can anyone explain why my approach is not working? I get the feeling I am somehow missing something here.

Cheers

Jan

Tooltip Question.zip 15.4 KB

1. Re: Tooltip not working - ATTR seems to be the issue

lei.chen.0 Jun 5, 2016 6:39 PM (in response to Jan Paulsen)

Hello Jan,

First I'd like to confirm your requirements.

- You want a bar graph showing the sum of value for category.
- You want sum of value for Germany and France showing in the tooltip.

If so, my solution would simply be,

[Tooltip Germany]: IIF([Country]="Germany",[Value],0)
[Tooltip France]: IIF([Country]="France",[Value],0)

Then drag them into Marks shelf.
You may notice that SUM is automatically added. That's all right.
Then include them in the tooltip.

As for ATTR, here's the description,
"Returns the value of the given expression if it only has a single value for all rows in the group, otherwise it displays an asterisk (*)"
In the bar graph, field country has multiple values, thus ATTR(Country) returns asterisk.

Regards
Like Show 0 Likes(0)

Actions
2. Re: Tooltip not working - ATTR seems to be the issue

Mahfooj Khan Jun 5, 2016 9:09 PM (in response to Jan Paulsen)

Hi,
Nothing wrong with your France tool-tip. Little modification required, simply remove the ATTR() from Country dimension and SUM() from value. Then drag it to tool-tip. It'll work. See the screen shot
Mahfooj
Like Show 0 Likes(0)

Actions
3. Re: Tooltip not working - ATTR seems to be the issue

Jan Paulsen Jun 8, 2016 3:24 AM (in response to lei.chen.0)

Thanks a lot, it works!!
Like Show 0 Likes(0)

Actions
4. Re: Tooltip not working - ATTR seems to be the issue

Jan Paulsen Jun 8, 2016 3:25 AM (in response to Mahfooj Khan)

Ok, very simple;-) Thank you for the help!
Like Show 0 Likes(0)

Actions