Group the bars by expression rather than dimension?
Hi friends,
Does anyone know of a way to change a QlikView bar chart to group the bars by expression rather than dimension?
My chart has one dimension (company_type:- my_company, peers) and five expressions (5 fiscal quarters).
Currently, the chart displays 5 bars (fiscal quarters) in each of the 2 dimension groups (company type) but I need to display the 2 bars (company type) in five groups (fiscal quarters), one group for each expression field.
Any ideas on how to accomplish that in a single chart?
Have you tried to use the expression grouping under Expression Tab? I am attaching the screenshot for your reference. If this does not work then please post the sample QV document.