Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
varshavig12
Valued Contributor

Different popup for different expression, in waterfall model

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

1 Solution

Accepted Solutions
manucamon
Valued Contributor III

Re: Different popup for different expression, in waterfall model

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!

19 Replies
jyothish8807
Honored Contributor II

Re: Different popup for different expression, in waterfall model

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

KC

Best Regards,
KC
varshavig12
Valued Contributor

Re: Different popup for different expression, in waterfall model

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

How is your waterfall looks? Dimension is Same?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
varshavig12
Valued Contributor

Re: Different popup for different expression, in waterfall model

Multiple expressions with no dimension

varshavig12
Valued Contributor

Re: Different popup for different expression, in waterfall model

Something like this:

where a is sum(something)

b is sum(something else)

etc

jyothish8807
Honored Contributor II

Re: Different popup for different expression, in waterfall model

Hi Varsha,

why dont you simple modify your label ?

Pfa sample.

Regards

KC

Best Regards,
KC
varshavig12
Valued Contributor

Re: Different popup for different expression, in waterfall model

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)

krishna4bo
Contributor

Re: Different popup for different expression, in waterfall model

Hi Varsha,

P F A.

Regards,

Krishna.

manucamon
Valued Contributor III

Re: Different popup for different expression, in waterfall model

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!!!