topic how to change dimension dynamically?? in QlikView

how to change dimension dynamically??

sushil353 — Wed, 24 Aug 2011 09:45:59 GMT

Hi All,

i need to change the x-axis dimention according to the selection made on a field values.. please look at the image below.

as given when day is selected then there is date in the X-axis.. further if week is selected then there should be week no and so on...

Please help me to sort out this problem.

Thanks

how to change dimension dynamically??

SunilChauhan — Wed, 24 Aug 2011 09:58:23 GMT

ya you can.

load * inline [

col

week

date

];

in dimension-> add expresssion

if(col='Week',weekfieldname,

if(col='Week',datefieldname)

take col as selection

Re: how to change dimension dynamically??

Wed, 24 Aug 2011 10:02:52 GMT

Hi Sushil,

yes you can macro it and dynamically set the dimension properties of your chart depending on your selection, please see the attatched example that will show you how to do it for dimensions (and also expressions plus chart type too)

hope this helps

how to change dimension dynamically??

kaushiknsolanki — Wed, 24 Aug 2011 10:09:08 GMT

Hi,

Have a look at the example here.

http://community.qlik.com/qlikviews/1077

Regards,

Kaushik Solanki

Re: how to change dimension dynamically??

Wed, 24 Aug 2011 10:19:10 GMT

ah knew I got my example from somewhere on here! Just couldn't where in my browse history