Discussion Board for collaboration related to QlikView App Development.
I am trying to figure something out.
i have a sales case in which i sell cars. i have VW, BMW and Audi's.
every week i get a report on the sales from this week. i can see which cars are selling the best each week.
i can also see the contribution of each car in %
The above table is easy to replicate in QV.
But now i want to see all weeks in the same table but i want to see the contribution of a Brand for each week and not the contribution on the year total.
is it possible to create it like that?
Solved! Go to Solution.
I have a master calendar which contains a week-field. that is not my question.
I want to know if it is possible to replicate my table above.
The % is calculated in the table and not a value in my datasource
you can create a straight table with week (or weekyear) and brand as dimensions. Also you can have the same amount expression as in your example. What will change is that your expression for the weekly contribution per brand has to be something like this:
sum(Amount) / sum(total <week> Amount)
of course, you may add any additional filter (with set analysis or direct selections) so you can get to the result you need,
hope this helps,