Hello, I'm quite new to Qlikview and has startet creating smaller applications in an already set-up database. The issue is that i have a dimension/listbox with different values, if i create a chart for example i can plot:
=avg({<ValueCategory={'Colour'}>}Value)
Here i can then replace both "Colour" and "Value" with a few other parameters (amount, setpoint etc.), plotting by date for example. This works fine, but if for example i would like to do an expression counting the number of items in "Value" for a specific item in the list and dividing by a specific amount of the items (from Colour for example) without selecting that in the list it self, i get stuck.
I can make it work by doing "=count({<Value={'>100'}>}Value)/count(Value)" but this of changes if i select something else than Colour in the list - is it possible to write it for the specific entry in the list, as "amount of numbers >100 of Colour(Value) / number of colour values"
I'm not sure what you mean - the product has a production date which relates it to the year and a recording date which relates it to the parameters in valuecategory in terms of calendar/time? Thanks for taking your time to help 🙂
The data model is quite big. So i just showed the fields which i want to be interacting with. Is it too far fetched to get an idea of what i want to do?
Yes, so far it is. If I don't know how the fields are related to each other then I have no idea what you're talking about. If you can't create a simplified, but complete data model then I'm afraid you're on your own. Or you can hire a consultant to help you on-site.
