topic Change Dimensions in Charts in QlikView

Change Dimensions in Charts

Tue, 01 Jun 2010 13:28:40 GMT

Hi,

I have created a bar chart with dimension as 'Month' and 'Sum(Sales)' as expression. Now I need to change Dimension in this chart by clicking list of dimensions available. e.g. If I click 'Year', Chart will give sum(sales) w.r.t year...likewise need to chnage for other dimensions one ata time.

Please let me know is there any macro to do so.

Thanks,

Sunil

Change Dimensions in Charts

Tue, 01 Jun 2010 13:50:19 GMT

You need per example...a year, month or day?

You need to create a group of dimensions, e put the group in dimensions....

after that, just click in the bar to change the dimension...

Change Dimensions in Charts

its_anandrjs — Wed, 17 Aug 2011 13:55:29 GMT

Hi,

Why do you use the cyclic or drill down group for that by the help of this when you create a cyclic group which ever dimensions you define in that group it works for that suppose you create Year-Quarter-Month-Week-Day all this dimensions. Than it will change by cyclic order of the orders.

Regards,

Anand