Multiple expressions on bar chart

Wed, 21 May 2014 12:00:03 GMT

I need to do a revenue by week bar chart, where the revenue is categorised by department to show a stack bar chart and where the user can filter by one or more departments.

The problem I have is that 'Department' isn't actually a field, therefore I can't simply add it as a 2nd dimension.

Each Department is defined by certain DESKS and SECTORS

I have been able to do a set analysis for each expression, which gives me a stacked bar chart but the issue is that I have no DEPARTMENT picklist my users can filter by if the only want one departments revenue figures displayed.

I thought about have one expression in the chart and then defining each department with a bookmark and having those bookmarks available to the user as an object on the page, but this doesn't enable the user to select multiple departments.

How do i get round this issue?!

thanks very much

alex

Re: Multiple expressions on bar chart

Gysbert_Wassenaar — Wed, 21 May 2014 12:08:31 GMT

The best way is to create the Department field in the script so you can use it as a dimension in your chart. Or perhaps you can try this approach: Users can map/group dimensions at run-time!

topic Re: Multiple expressions on bar chart in QlikView

Multiple expressions on bar chart

Re: Multiple expressions on bar chart