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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Simon4
Creator
Creator

Excluding date KPI

Hi all,

 

I looked around on the forum but I could not get to the solution.

 

I want to exclude the date 01-01-9999 from Planneddate

=avg(Goodsreceiptdate-Planneddate)

 

Can anybody help me? 

 

Thanks in advance,

 

Simon

Labels (1)
2 Replies
BrunPierre
Partner - Master II
Partner - Master II

Try

Avg({<Planneddate-={'01-01-9999'}>}Goodsreceiptdate-Planneddate)

vinieme12
Champion III
Champion III

Try below

=avg({<Planneddate-={'01-01-9999'}>}Goodsreceiptdate-Planneddate)

 

Or below, where ID is field that identifies each record separately 

=avg({<

ID=e({<Planneddate={'01-01-9999'}>}ID)

>}Goodsreceiptdate-Planneddate)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.