Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Frank_Fu
Contributor
Contributor

Measure only shows up for selected date

Hi folks,

Hoping some one can help me as I got an issue with a chart (see below). only number for selected month shows up for this line chart while I need it shows up for all periods.

the measure looks like:

sum(aggr(sum(Target),SKU)*aggr(sum(Multiplier),SKU))

as I needed to aggregate two measures at sku level and multiply them to get the final number.

The dimension is calendar month. Thanks in advance for any help. 

 

Measure only shows to selected date.PNG

0 Replies