topic Re: Different popup for different expression, in waterfall model in QlikView

Different popup for different expression, in waterfall model

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

Can we have a different pop up for different expressions in waterfall model ? Or is there any workaround to do the same ?

Re: Different popup for different expression, in waterfall model

jyothish8807 — Fri, 14 Oct 2016 04:39:58 GMT

Hi Varsha,

Can you explain your query a bit more ?

Normally in a waterfall chart each expression will have pop up corresponding to its expression and label name.

Regards

Re: Different popup for different expression, in waterfall model

varshavig12 — Fri, 14 Oct 2016 04:46:47 GMT

Hi Jyothish,

We need a popup text with some more details w.r.t each expression.

eg:

I have 2 bars in my waterfall

I want to have a pop up for the first one as : 'Label name' has value '$(value)' due to increase in '$(factor)'

and may be a simple one for second: 'Label name' and its value

Just like a ppt, we prepare for business.

Re: Different popup for different expression, in waterfall model

Anil_Babu_Samineni — Fri, 14 Oct 2016 05:05:18 GMT

How is your waterfall looks? Dimension is Same?

Re: Different popup for different expression, in waterfall model

varshavig12 — Fri, 14 Oct 2016 05:09:11 GMT

Multiple expressions with no dimension

Re: Different popup for different expression, in waterfall model

varshavig12 — Fri, 14 Oct 2016 05:12:52 GMT

Something like this:

where a is sum(something)

b is sum(something else)

etc

Re: Different popup for different expression, in waterfall model

jyothish8807 — Fri, 14 Oct 2016 05:20:34 GMT

Hi Varsha,

why dont you simple modify your label ?

Pfa sample.

Regards

Re: Different popup for different expression, in waterfall model

varshavig12 — Fri, 14 Oct 2016 05:28:35 GMT

Considering the below as an example:

If I modify the label, I will reflect on my x-axis too, Right ?

For my first bar, the green color one,

I want its label to be 'a'

and a pop up as : 'The value of a is' & $(value)

Re: Different popup for different expression, in waterfall model

Anonymous — Fri, 14 Oct 2016 06:45:06 GMT

Hi Varsha,

P F A.

Regards,

Krishna.

Re: Different popup for different expression, in waterfall model

Anonymous — Fri, 14 Oct 2016 06:50:40 GMT

Hi Varsha,

Use dual expression for it.

Your Expression must be like this:

Dual(Text,Value), for example: Dual('Label name has value '&$(value) &' due to increase in '&$(factor),1.5)

Your value represented on chart will be 1.5, but you will see on pop-up the text.

Regards!!!

Re: Different popup for different expression, in waterfall model

varshavig12 — Fri, 14 Oct 2016 07:05:46 GMT

Hi Manuel,

I want something like this:

if I use dual() then the value on data point will not be just 308, it will give me everything I write for a pop up.

like this:

Re: Different popup for different expression, in waterfall model

varshavig12 — Fri, 14 Oct 2016 07:08:28 GMT

I cannot open your qvw now, Ill check this and let you know in an hour.

Else, if possible can you please post a screenshot of your graph with pop up ?

Re: Different popup for different expression, in waterfall model

jyothish8807 — Fri, 14 Oct 2016 07:40:39 GMT

Hi Varsha,

As a work around, you can create two identical charts. One with proper expresion and enable value at data point and one duplicate using dual function and disable value at data point in that chart and superimpose each other.

This might be tough, but could be a work around.

Regards

Re: Different popup for different expression, in waterfall model

Anonymous — Fri, 14 Oct 2016 07:42:37 GMT

Hi Varsha, try this solution.

I have duplicated the expression, and I have changed all expressions with only 1 expression and 1 dimension,using pick for calculate each expression. Check all options please.

Regards!

Re: Different popup for different expression, in waterfall model

varshavig12 — Fri, 14 Oct 2016 08:01:17 GMT

I have done this using pick match only ,making it one exp, alot of if else. So I just wanted to avoid this.

Also, I have to then write big expressions for offset, background and everything.

But, if I don't get anything else then I will keep my application the way it is.

Re: Different popup for different expression, in waterfall model

varshavig12 — Fri, 14 Oct 2016 08:02:41 GMT

Sorry, but I don't want to duplicate it.

Re: Different popup for different expression, in waterfall model

varshavig12 — Fri, 14 Oct 2016 08:06:24 GMT

I cannot open your app, Using P.E for now.

But this is what I have done. PFA the qvw.

Can you please let me know if this is exactly what you have done in your app.

Re: Different popup for different expression, in waterfall model

Anonymous — Fri, 14 Oct 2016 08:08:09 GMT

Hi Varsha,

This is the only way that I know to do it if you want to show different pop-ups of the value shown on chart and with only one chart.

Regards!!

Re: Different popup for different expression, in waterfall model

varshavig12 — Fri, 14 Oct 2016 08:15:03 GMT

Hi Manuel,

I think that this is the only solution we have for now (pick(match)).

So, I will keep my application, the way it is.

Thanks a lot!!

Re: Different popup for different expression, in waterfall model

Anonymous — Fri, 14 Oct 2016 08:18:36 GMT

You're wellcome!