topic Re: Dynamic variance chart in QlikView

Dynamic variance chart

Fri, 04 Apr 2014 18:25:19 GMT

Hi,

My input table looks something like below:

Version, Region, Sales

v1, Asia, 120000

v2 , Asia, 130000

v3, EMEA, 1456000

v3, Asia, 3455600

v1, EMEA, 345600

v2, EMEA, 2323242

v1, NA, 3456700

v2, NA, 4545490

v3, NA, 84754540

I'm trying to populate a dynamic variance chart with that..

Variance chart should be produced dynamically for any two versions based on user selection: (v1,v2) or (v2,v3) or (v1,v3)..so on..and versions can grow over time.

is it possible?

I have a draft version attached, right now the variance chart is fixed in the app. Want to make it dynamic.. Appreciate your help.

Re: Dynamic variance chart

whiteline — Fri, 04 Apr 2014 18:33:08 GMT

Hi.

It's possible. The easiest way is to use alternate states for comparison. There is a good standard example ('what's new' or so) within QV 11 installation if my memory serves me right.

Or you can easily find some useful posts about alternate states here in the community.

Re: Dynamic variance chart

Fri, 04 Apr 2014 21:37:29 GMT

thank you. I'll search and see.