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: 
yvonne-c
Creator
Creator

Chart to ingore date selections

Hi

I want to make a change to the following expression so that my chart includes all dates and ignores my date selections, can anybody help with this?

Sum({$<[Target Weight]={600},Class-={Nil}>}Aggr(Sum(Quantity)/[Calculated Cow Course],Product,ReferredTo,Year))

Thanks

1 Solution

Accepted Solutions
sunny_talwar

May be try this:

Sum({$<[Target Weight]={600},Class-={Nil}, Date>}Aggr(Sum({<Date>}Quantity)/Only({<Date>}[Calculated Cow Course]),Product,ReferredTo,Year))

View solution in original post

2 Replies
sunny_talwar

May be try this:

Sum({$<[Target Weight]={600},Class-={Nil}, Date>}Aggr(Sum({<Date>}Quantity)/Only({<Date>}[Calculated Cow Course]),Product,ReferredTo,Year))

Not applicable

sum({<Date=>})