topic Re: Showing totals when hovering in QlikView

Showing totals when hovering

Mon, 22 Feb 2016 08:01:23 GMT

I know you can show totals when hovering on a bar chart. But my totals on my expressions are all divided by millions, so it you hover ot shows 121 for 121435000, so how do I show the full total while hovering?

Re: Showing totals when hovering

kaushiknsolanki — Mon, 22 Feb 2016 08:05:56 GMT

Hi,

have a look at the link below.

mouseover label

Regards,

Kaushik Solanki

Re: Showing totals when hovering

Anonymous — Mon, 22 Feb 2016 08:06:26 GMT

Did you try with Text as a PopUp??

Properties -> Expression -> Text as a PopUp

Re: Showing totals when hovering

Tue, 29 Mar 2016 08:20:53 GMT

This works well if there is only one bar chart, but say you have more than one bar, how do you link the popup label to the correct bar

Re: Showing totals when hovering

Chanty4u — Tue, 29 Mar 2016 08:24:10 GMT

hi,

u can use

='urtext ' &Chr(10)&'Expresion'

Re: Showing totals when hovering

Tue, 29 Mar 2016 08:52:07 GMT

I have done this it works fine for values over a million,Most of my bars are more than a million, so I have the Y Axis as million values.

See attached document

The code for example is with or without the /1000000

if(MonthName=1,sum({$<MonthName=,AccountType = {P},MonthNum = {1},CapitalTypeShort = {'Intangible'}>}BudgetDistributionCalculation + BudgetMovementMonthly),

if(MonthName=2,sum({$<MonthName=,AccountType = {P},MonthNum = {1,2},CapitalTypeShort = {'Intangible'}>}BudgetDistributionCalculation + BudgetMovementMonthly),

if(MonthName=3,sum({$<MonthName=,AccountType = {P},MonthNum = {1,2,3},CapitalTypeShort = {'Intangible'}>}BudgetDistributionCalculation + BudgetMovementMonthly),

if(MonthName=4,sum({$<MonthName=,AccountType = {P},MonthNum = {1,2,3,4},CapitalTypeShort = {'Intangible'}>}BudgetDistributionCalculation + BudgetMovementMonthly),

if(MonthName=5,sum({$<MonthName=,AccountType = {P},MonthNum = {1,2,3,4,5},CapitalTypeShort = {'Intangible'}>}BudgetDistributionCalculation + BudgetMovementMonthly),

if(MonthName=6,sum({$<MonthName=,AccountType = {P},MonthNum = {1,2,3,4,5,6},CapitalTypeShort = {'Intangible'}>}BudgetDistributionCalculation + BudgetMovementMonthly),

if(MonthName=7,sum({$<MonthName=,AccountType = {P},MonthNum = {1,2,3,4,5,6,7},CapitalTypeShort = {'Intangible'}>}BudgetDistributionCalculation + BudgetMovementMonthly),

if(MonthName=8,sum({$<MonthName=,AccountType = {P},MonthNum = {1,2,3,4,5,6,7,8},CapitalTypeShort = {'Intangible'}>}BudgetDistributionCalculation + BudgetMovementMonthly),

if(MonthName=9,sum({$<MonthName=,AccountType = {P},MonthNum = {1,2,3,4,5,6,7,8,9},CapitalTypeShort = {'Intangible'}>}BudgetDistributionCalculation + BudgetMovementMonthly),

if(MonthName=10,sum({$<MonthName=,AccountType = {P},MonthNum = {1,2,3,4,5,6,7,8,9,10},CapitalTypeShort = {'Intangible'}>}BudgetDistributionCalculation + BudgetMovementMonthly),

if(MonthName=11,sum({$<MonthName=,AccountType = {P},MonthNum = {1,2,3,4,5,6,7,8,9,10,11},CapitalTypeShort = {'Intangible'}>}BudgetDistributionCalculation + BudgetMovementMonthly),

if(MonthName=12,sum({$<MonthName=,AccountType = {P},MonthNum = {1,2,3,4,5,6,7,8,9,10,11,12},CapitalTypeShort = {'Intangible'}>}BudgetDistributionCalculation + BudgetMovementMonthly),

sum({$<MonthName=,AccountType = {P},MonthNum = {1},CapitalTypeShort = {'Intangible'}>}BudgetDistributionCalculation + BudgetMovementMonthly)

))))))))))))/1000000

Re: Showing totals when hovering

Tue, 29 Mar 2016 08:53:58 GMT

Not making sense to me, see the other reply I did with the Word document

Re: Showing totals when hovering

avinashelite — Tue, 29 Mar 2016 10:05:46 GMT

Try with the dual() function

How to use- Dual()

Re: Showing totals when hovering

Tue, 29 Mar 2016 10:45:57 GMT

Not sure I quite understand where you want me to use it. I already use the Dual Function with Month name and Month number combined. Do you mean having a dual with the million rounded and the full value? We have to use it as our Financial Month are June = 1, July = 2, so I am forced to use it for ordering purposes as well, so I can order months by numbers.

My issue is more related to the following

When values are more than a million, I have the Y-axis showing the values in millions, but when I hover it shows the full value

But when the values are less than a million, I still need the Y axis to show the values in millions, for example 250 000 as 0.25 and when hovering it will show 250 000

Re: Showing totals when hovering

avinashelite — Tue, 29 Mar 2016 10:54:30 GMT

I think your formatting the number in the Number tab? if so this situation is common , try to handle the format in the Expression this will be always consistent...

Do you mean having a dual with the million rounded and the full value?

Yes , I asked you to use dual function for this type of formatting

Re: Showing totals when hovering

Tue, 29 Mar 2016 11:08:04 GMT

But how do I differentiate between the two, when using it, its easy enough with a text and a number field in the Dual, how would it work with two number, for example Dual(250000,0.25). Am I understanding you correctly?

Re: Showing totals when hovering

avinashelite — Tue, 29 Mar 2016 11:10:08 GMT

try like this

DUAL( your_expression, your_expression/1000000)

Re: Showing totals when hovering

Tue, 29 Mar 2016 11:32:14 GMT

Can you do it on the actual expression inside a chart or in the load statement, there are some really small values involved in single rows, so would you out lose a lot of data, example 500 would be 0.000500, Qlikview would keep these values?

Still the remaining issue is, seeing as they are two numeric values, how do I differentiate between they two in a chart, how do I select it I want to use the million value or the full value?

Hope I am making sense

Re: Showing totals when hovering

avinashelite — Tue, 29 Mar 2016 11:39:10 GMT

Qlikview will not ignore any values

dual(expression1,expression2) functions like this

In dual expression1 will be considered for your hover display but for the chart the value of the expression2 is considered .

EG: if you have dual(Month_name,Month_value) then

while building the chart your Y Axis will be generated according to the Month_value but will showing it in the hover the value of Month_name is displayed .

In your case dual() function will help you to set the Y axis always set to M and it the hover it will show the actual values

hope this makes better

Re: Showing totals when hovering

Tue, 29 Mar 2016 12:08:08 GMT

It helps, but I am still unsure how you deal with the two numeric values, how do I code it to use the one for the Hovering and one for the Y Axis? Do you maybe have an example? I have only used Dual for a text and numeric before, never with two numeric values.

Sorry for all the questions, just can't get my head around the two numeric values, maybe I am just overcomplicating it

Re: Showing totals when hovering

avinashelite — Tue, 29 Mar 2016 12:11:08 GMT

nothing to worry with the 2 numeric values dual will handle it.

how do I code it to use the one for the Hovering and one for the Y Axis?

dual(expression,expression/10000000)

here expression will be considered for the hover and expression/10000000 will be set for the Axis you need to worry on this part try with the expression

Re: Showing totals when hovering

Tue, 29 Mar 2016 12:12:07 GMT

Just remember I have more than one bar in a chart. I saw some examples where its easy with only one bar i a chart adding an extra field. I also have line charts where I do the hovering, but it should be the same principle.

As said before I have got it working with my charts with values more than a million

Re: Showing totals when hovering

Tue, 29 Mar 2016 12:13:46 GMT

Will it autoselect which one to use for Y axis and which to use for hovering?

Re: Showing totals when hovering

avinashelite — Tue, 29 Mar 2016 12:16:31 GMT

yes , 1st part is for hovering and 2 part is for the y axis

Re: Showing totals when hovering

Tue, 29 Mar 2016 12:42:44 GMT

Will try this and let you know. Thanks so much for the help sofar