Dynamic variance chart

[#1]

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.

[whiteline]

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.

[#3]

thank you. I'll search and see.