topic Re: Hover in Combo chart in QlikView

Hover in Combo chart

Lakshman_1031 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have combo chart and i have used Custom Hover.

I have used Expression in Hover is

='Profit as'& Only({< Month, Year>}Aggr(NODISTINCT Sum(Profit),Year))

If i select year 2020 all the years showing in x-axis and data showing only year 2020.

I want to show only if i select 2020 then display in chart only 2020 on x-axis.

please see the below example for your reference.

Please suggest me is it possible to achieve this scenario, if possible please share example.

Thanks & Regards,

lakshman

Re: Hover in Combo chart

tresB — Thu, 12 Mar 2020 06:50:50 GMT

Remove only() from your pop-up expression.

='Profit as'& Aggr(NODISTINCT Sum(Profit),Year)

Re: Hover in Combo chart

Lakshman_1031 — Thu, 12 Mar 2020 09:37:07 GMT

Hi Tresesco,

Thanks for your quick replay.

Is it possible to achieve same scenario without using Aggr(NODISTINCT).

If possible please suggest me how to do.

Thanks & Regards,

Lakshman

Re: Hover in Combo chart

tresB — Thu, 12 Mar 2020 09:56:19 GMT

It seems that you are getting at tool tip the total sum irrespective of dimension, that you probably can do like:

='Profit as'& $(=Sum(Profit))

Re: Hover in Combo chart

sunny_talwar — Thu, 12 Mar 2020 11:47:30 GMT

May be this

='Profit as'& Aggr(Sum(TOTAL <Year> Profit), Year, Quarter)

Re: Hover in Combo chart

Lakshman_1031 — Thu, 19 Mar 2020 10:08:14 GMT

Hi Sunny,

Thanks for your replay.

I have used same thing in months but i am facing issues.

i have used expression in month

SUm({<Flag2={1}>}Sales)/Aggr(Sum(TOTAL<Year>{<Quarter=,Month=, Year=>}Sales),Year,Month).

if i used custom hover then i am facing issues .

i have created one flag for present data and future data. i have used this flag in hover then x axis showing all the values.

Please see the below example for your reference.

Please suggest me how to achieve this scenario, if possible please share example.

Thanks & Regards,

lakshman

Re: Hover in Combo chart

sunny_talwar — Thu, 19 Mar 2020 12:06:44 GMT

I am not sure I follow the issue? Can you explain what you need to see with or without selection in the attached sample?

Re: Hover in Combo chart

Lakshman_1031 — Fri, 20 Mar 2020 04:29:40 GMT

Hi Sunny,

Thanks for your replay.

I have created one flag for current data and future data.

i have restricted future data using flag.

Based on the flag data it is Showing current data line and remaining data is not showing.

For example in the example having 2020 may data and up to May line showing and remaining is not showing any thing.

but line is not showing but x axis is showing 2021 data without line.

i don't want to show if line is not there. without using Hover it's working fine but when i used Custom hover it is not working.

Please suggest me how to achieve this scenario.

Thanks & Regards,

lakshman