Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to dynamically change the chart?

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?

4 Replies
Not applicable
Author

Hi

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

sunny_talwar

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

swuehl
MVP
MVP

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

MarcoWedel

Hi,

one solution might be:

QlikCommunity_Thread_217777_Pic1.JPG

QlikCommunity_Thread_217777_Pic2.JPG

QlikCommunity_Thread_217777_Pic3.JPG

Dimension:

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

Expression:

=Sum(sales)+0*Now()

hope this helps

regards

Marco