Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Calculation of sum of values Picking up String

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?

Please suggest.

Thanks,
Shan

1 Solution

Accepted Solutions
Highlighted

Hi,

Try expression

=Sum( if( Left(InvoiceID,2) = 'CR' , LineAmount))

Regards

Anand

View solution in original post

3 Replies
Highlighted

Hi,

Try expression

=Sum( if( Left(InvoiceID,2) = 'CR' , LineAmount))

Regards

Anand

View solution in original post

Highlighted
Creator III
Creator III

Hi Anand,

Thanks for the quick response. I got the exact answer.

I really appreciate it!

Thanks,

Shan

Highlighted

Hi,

Thanks, Close the thread by selection appropriate answer Correct or helpful.

Regards

Aannd