Discussion board where members can get started with QlikView.
I have a table with a field of InvoiceID, value begins with CR and DB and i have to sum the LineAmount picking only the value start with CR.
How do i do that? Is there any clue about that?
=Sum( if( Left(InvoiceID,2) = 'CR' , LineAmount))
View solution in original post
Thanks for the quick response. I got the exact answer.
I really appreciate it!
Thanks, Close the thread by selection appropriate answer Correct or helpful.