Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sushil353
Master II
Master II

how to change dimension dynamically??

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.

time2.bmp

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

4 Replies
SunilChauhan
Champion
Champion

ya you can.

load * inline [

col

week

date

];

in dimension-> add expresssion

if(col='Week',weekfieldname,

if(col='Week',datefieldname)

take col as selection

Sunil Chauhan
Not applicable

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

    Have a look at the example here.

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable

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