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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
anuradhaa
Partner - Creator II
Partner - Creator II

Get number of records

I want to get the sum(records) and i'm using below expression, but it doesn't give any value

=sum({$<nw_CAL_RULE_TIME={"$(=date(ReloadTime()-1,'DD-MM-YYYY'))"}>}

if((CAL_RULE_TIME-RULE_ICR)*24 < 80 , if(Len(Trim("RULE_RBL")) = 0 and Len(Trim("RULE_RLO")) = 0 and Len(Trim("RULE_RMT")) = 0,

if(Len(Trim("Rule_HIS_BAD")) = 0,if(Len(Trim("HOLD_DTM")) = 0 and Len(Trim("TO_ROADMARK")) > 0,

count(RULE_ICH))))))

please correct me

0 Replies