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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Comparing Data in a Straight table

Hi All,

I am very new to Qlikview so please point me in the right direction. I have a straight table:

Dimentions:

Code, Description,InvNumber,DeliveryNote

Expressions:

Items = Sum(Sales Order Qty) - Sum(Credit Note Qty)

Will it be possible to only subtract the credit note qty if the InvNumber = DeliveryNote in the selection, else ignore credit note qty. I've attached a print screen.

Thanks,

Labels (1)
10 Replies
Not applicable
Author

Hi Miguel,

Could you please give me the syntax for 8.5?

Thanks,