Discussion Board for collaboration related to Creating Analytics for QlikView.
So I have a problem I can't seem to think my way around:
i have a dataset of trucks with certain profits, costs and margins.
To analyse these trucks, i will need to split them up into 3 groups:
- Best Trucks ( above +10% of average margin)
- Average Trucks (between +10% and -10% of average margin)
- Not so good Trucks. (below -10% of average margin)
now i want to create a field that when i click on 'average', the set with margin between +10% and -10% is filtered (on the same way as when you select a specific month in the dataset).
so I figured i would have to use avg(TOTAL Margin), but i don't know how to make a field using the statement..
it would be awesome if you can help me!
You can find the avg margin in script itself using resident load
Create an avg at truck level with group by using another resident load
now join the 2nd to the first and create a flag ...
Kindly provide sample data to work..
I tried it, but you cannot use the 'total'statement in the script.
see attached files in original message.
Note that 'Omzet' = Profit, 'Kosten'=Costs and 'BrutoMarge'= Margin