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

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Gayam
Contributor
Contributor

Unbilled amount

Hello, 

Below condition is used to get unbilled amount in unallocated payment report in sql query. Without using that condition the unbilled amount is not matching. How to use that condition in qliksense?  Any changes needed? 

=if([Account no]=previous([Account no]);0; sum(To number([check no] In ([ Account no]))))+0

Labels (1)
0 Replies