Dynamic Show Hide of Images

[#1]

Hi Team,

I have to replicate the above scenario in QlikView.

I have three metric Contact, Act and Engaged.

The metrics goes like -

Contact is no. of people we contacted,

Act - No. of people acted and

Engaged - No. of people who got engaged to our policy.

Calculation goes this way : The left hand side numbers are used to get the ratio (i.e. Contact :87,792, Act:12,876 and Engaged : 3,923)

1) Contact - Total no. of contact (10 static Images to be displayed always)

2) Act - Act/Contact (Images should b displayed based on the ratio calculated, so we will have to apply condition on every image, like 1 image - 1/10 i.e. Act/Contact, 2 image - 2/10, 3 image - 3/10 and so on till 10th image)

3) Engaged - Engaged/Contact (Images should b displayed based on the ratio calculated same way show and hide of images based on the ratio)

So lets say, for Act if we have 3/10 ratio then 3 images should be displayed and same for Act

Can you please suggest me, what conditions/calculation/variables can we applied to get this work.

Let me know if you require any more inputs.

Thanks in advance.

[#2]

Can you give some more details of your problem, may be with qvw ffile, so that we could solve it??

Thanks

Ganesh kumar R

[#3]

Hi Prakash,

one way is to use Ceil(Act/Contact, 0.1) >= .1, .2, etc. as a condition. In the attached file you can see how this works and test it with different values using the input box.

Another approach is described here, great post by qvdesign: The Simplest of Tricks to Further Enable Qlikview Interactive Infographics. (*Still requires common ...

Best,

Ivelin