Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
yvonne-c
Contributor

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

Re: Chart to ingore date selections

May be try this:

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

2 Replies

Re: Chart to ingore date selections

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

Re: Chart to ingore date selections

sum({<Date=>})