topic how to dynamically change the chart? in QlikView

how to dynamically change the chart?

Wed, 25 Nov 2020 16:16:04 GMT

Hi all

i have dimensions country,region,state,year,month.

first chart show the country wise sales.after with out user selection chart show region ,month,year wise sales.automatically it will change the dimension .how?

Re: how to dynamically change the chart?

Sat, 21 May 2016 10:49:40 GMT

you can create cyclic group(Year,month) or drilldown(Country,region, state) group .Then you can use the these group as dimension in chart and

in expression tab write the expression.

Regards

tripati

Re: how to dynamically change the chart?

sunny_talwar — Sat, 21 May 2016 11:12:57 GMT

Without selection? Not sure I understand your requirement completely. Would you be able to elaborate? May be you are looking for Cycle Group???

Creating Cycle and Drill Groups

Re: how to dynamically change the chart?

swuehl — Sat, 21 May 2016 11:50:05 GMT

If you are looking for some kind of slide show, time triggered change of the charts shown, have a look at my answer here:

Re: Dynamic Chart Swapping

Re: how to dynamically change the chart?

MarcoWedel — Sun, 22 May 2016 00:09:45 GMT

Hi,

one solution might be:

Dimension:

=Pick(Floor(fmod(Now()*86400/vInterval,5)+1),country,region,state,year,month)

Expression:

=Sum(sales)+0*Now()

hope this helps

regards

Marco