Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
ya you can.
load * inline [
col
week
date
];
in dimension-> add expresssion
if(col='Week',weekfieldname,
if(col='Week',datefieldname)
take col as selection
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
Hi,
Have a look at the example here.
http://community.qlik.com/qlikviews/1077
Regards,
Kaushik Solanki
ah knew I got my example from somewhere on here! Just couldn't where in my browse history