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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
kiru_18
Contributor II
Contributor II
‎2021-05-19 03:55 AM

Sum the values based on conditions

Hi,

I need to sum 2 values based on some condition. I have entrydate, invoicedate, entryquantity, invoicequantity fields.

Requirement: If entrydate is selected it should sum entryquantiy and result is sum of entryquantity, if invoicedate is selected then it should Sum the invoicequantity and result is sum of invoicequantity.

This expression i need to build in one column in pivot table. 

Labels (2)
Labels
602 Views
1 Reply
Or
MVP
MVP
‎2021-05-19 04:23 AM

Sum(If(GetSelectedCount(entrydate)>0,entryquantiy, if(GetSelectedCount(invoicedate)>0,invoicequantity)))

577 Views
0 Likes