Please check out the attached and see if it helps. There wasn't enough data to get proper resuts but with a full data set it should be fine. You can test it out and see.
Test2.qvw 511.0 K
thanks for the quick reply, it's cool to display it for a dashboard, but I'd like to keep the possibility to further analyse the data, which I loose if I pre-aggregate the data.
The whole dataset is arranged as star-topology and contains some master data about the orders and customers and so on, therefore, I'm looking for something similar to a if-statement but with better calculation times.
maybe this is what you are looking for:
I transformed your table a bit, using the crosstable prefix, in order to get one single date column.
By this you should keep the possibility to further analyse the data using your other dimensions.
Here is the code:
CrossTable (type, date, 2)
auftrag_datum as order,
addmonths(vorst_datum,-12) as consumption
(biff, embedded labels);
MonthName(date) as month
hope this helps
QlikCommunity_Thread_109465.qvw 554.8 K