Hello guys,
I have created a line graph where dimension is the week number and the measure shows sum of KG.
The formula for the measure is as follows: =sum(aggr(Sum("[KGQuantity]")*-1,Index))
I have received proper order of weekes on x-axis after creation of master calendar but the labels of line of the graph do not show proper values of sums of KG. After selection of e.g. 1 week the sum of kg is correct.
I found somewhere on qlik community that the reason of that might be definition of variables which I am using for the purpose of master calendar but not sure:
MinMaxTable:
Load
min(SaleDate) as MinDate,
max(SaleDate) as MaxDate
Resident [sale2018];
Let vMinDate = Num(Peek('MinDate', 0, MinMaxTable));
Let vMaxDate = Num(Peek('MaxDate', 0, MinMaxTable));
drop table MinMaxTable;
Whait is the reason of such situation? Could you assist?