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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
c20088ac
Contributor
Contributor

Eliminate Filter and eliminate null values from field in set analysis

Sum({<Processes = {"=Len(Processes)>0"}, Date=>}Aggr(Max({<Processes = {"=Len(Processes)>0"}, Date=>}TE),Comment, Processes , Date))

 

Hello, I am trying to eliminate the null values from the processes field and eliminate the filtering on the Date field, but this does not work. Could you please help me? 

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

A clarification, do you want to ignore the selection on the date field? If so, then maybe like this

Sum({<Date>}{<Processes={"=Len(Trim(Processes ))=0"}>}Aggr(Max({<Date>}{<Processes={"=Len(Trim(Processes ))=0"}>}TE),Comment, Processes,Date))

vinieme12
Champion III
Champion III

try below

Sum({<Processes -= {""}, Date=>}Aggr(Max({<Processes -= {""}, Date=>}TE),Comment, Processes , Date))

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