Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a division listbox linked to to the chart. when i select any field from the listbox, only the blue bar changes. the green bar still shows the overall value and not the corresponding value of the selected field from the dropdown.
Help on this would be appreciated.
It does changing for Division SUBS.
QlikView will respond to your selections with the associated data.
In you data model it will depend upon how Division is related to Resource
It is changing, but the values for "resource" are pretty much the same for all of your quarters for all of your divisions. It's an error with your data model. Create a straight table with Division and Quarter as your dimensions and Sum(Resource) as your expression and you'll see what I mean.
There are a number of solutions relating to your data model, you'll need to look at how you're joining the data and what granularity it loses as you're joining them. How is the data meant to relate?