Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Edyta
Contributor III
Contributor III

Wrong values on line chart when dimension is unselected

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?

Labels (1)
0 Replies