topic Re: Help in creating Custom pop up name for stacked chart in QlikView

Help in creating Custom pop up name for stacked chart

jyothish8807 — Fri, 29 May 2015 08:14:14 GMT

Hello All,

I have a chart like below. I have two expression which i am using to create a stacked chart.

So i want a pop "Sale of India: 100" when i mouse over blue part of Dimension A.

Pop up "Total Sale of India: 230" when i mouse over red part of Dimension A.

Pop up" Sale of US: 200" when i mouse over blue part of Dimension B and so on.

Hope i am able explain my requirement. Any help will be appreciated.

Regards
KC

Re: Help in creating Custom pop up name for stacked chart

jyothish8807 — Fri, 29 May 2015 08:30:06 GMT

jaganmohan‌ any help on this?

Re: Help in creating Custom pop up name for stacked chart

awhitfield — Fri, 29 May 2015 08:37:44 GMT

Hi,

can you upload your qvw? Or A sample

Andy

Re: Help in creating Custom pop up name for stacked chart

jyothish8807 — Fri, 29 May 2015 08:51:07 GMT

Sorry its a huge app..

in Label iam trying to write for expression 1:

if(Dimension='A','Sale of India:,if(Dimension='B','Sale of US:'))

But it is not working.

Regards

Re: Help in creating Custom pop up name for stacked chart

jyothish8807 — Fri, 29 May 2015 08:52:23 GMT

Here Dimension is my field name and its value is A,B,C,D.

Re: Help in creating Custom pop up name for stacked chart

awhitfield — Fri, 29 May 2015 08:56:07 GMT

No problem, what are your expression, so we can mock up an example?

Andy

Re: Help in creating Custom pop up name for stacked chart

jyothish8807 — Fri, 29 May 2015 09:07:50 GMT

Attached a sample.

In dis when i mouse over the bar '-' is coming.I have to fix this.

Regards

Re: Help in creating Custom pop up name for stacked chart

awhitfield — Fri, 29 May 2015 09:21:50 GMT

What you have got will only work when you had made a selection in a list box etc, If dimension A = India, then why not rename it as such?

Re: Help in creating Custom pop up name for stacked chart

jyothish8807 — Fri, 29 May 2015 09:30:16 GMT

The issue is that for Exp1 and Exp 2 i have to show different (Custom Names ) apart from Dimension name.

Regards

Re: Help in creating Custom pop up name for stacked chart

Fri, 29 May 2015 09:36:19 GMT

Hi Jyothish,

I think, this post may help you.

mouseover label

Re: Help in creating Custom pop up name for stacked chart

Fri, 29 May 2015 09:50:40 GMT

Hi,

Check the attached report.

Hope it will help you.

Regards

Sindhu Kannan.

Re: Help in creating Custom pop up name for stacked chart

jyothish8807 — Fri, 29 May 2015 09:59:39 GMT

Thanks a lot... this should help. Let me try and get back to you.

Re: Help in creating Custom pop up name for stacked chart

jyothish8807 — Fri, 29 May 2015 10:07:47 GMT

Sorry but two pop up are coming for both upper and lower part of the stack chart. I need only one for each part.

Re: Help in creating Custom pop up name for stacked chart

prajapatiamar38 — Fri, 29 May 2015 10:17:38 GMT

Hi....

Please find the attached qvw below

I hope this want you exactly.

Re: Help in creating Custom pop up name for stacked chart

jyothish8807 — Fri, 29 May 2015 10:44:14 GMT

Thanks for the help but still there is one issue.

My pop up are not standard.

For Dimension A: it is India and US

For Dimension B: It is Spain and Portugal

Regards

Re: Help in creating Custom pop up name for stacked chart

jyothish8807 — Sat, 30 May 2015 06:22:36 GMT

Thanx Chandran, i have tried this approach but still it is not fulling my requirements.

Regards

Re: Help in creating Custom pop up name for stacked chart

terezagr — Sun, 31 May 2015 11:44:12 GMT

Hi,

I have used alternate states and assigned them to dimensions. See attached example

Hopefully, this is what you have asked for.

Re: Help in creating Custom pop up name for stacked chart

jyothish8807 — Mon, 01 Jun 2015 06:49:40 GMT

Thanks for the help Tereza, but still this is not what i am looking for.

Regards