Discussion Board for collaboration related to Creating Analytics for QlikView.
The tast is to calculate turnover and quantity of good by different periods and it's dynamics form the firs period and from previous,
to see how values change.
so in a table we need to calculate by products/stores (2 demension in a group for a fast change in table) and periods (day/week/month/year in a group - change is also allowed).
3) increase of turnover/quantity from the first period in absolute value.
4) increase of turnover/quantity from the previous period in absolute value.
3) increase of turnover/quantity from the first period in %.
4) increase of turnover/quantity from the previous period in %.
see table as example,
Go to Solution.
We managed to do this, before is not enough for calculation from the first period, but thanks for help (2 Kaushik.solanki).
and the sames with charts (lines) to see the increase
What ever i am able to do is in this example.
Hope this will help you