Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
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