topic Re: KPI Question in QlikView

KPI Question

Wed, 25 Nov 2020 16:16:04 GMT

I'm new to Qlik, I need to know how to create a KPI by summing an Amount field based on the value of another field.

for example, I want a KPI that sums Amount for only the Status = A.

KPI = 50

Line Amount Status

01 10.00 A

02 20.00 A

03 15.00 I

04 20.00 A

swuehl — Mon, 14 Mar 2016 23:26:07 GMT

You can use either use

=Sum( If( Status = 'A', Amount))

or with a set expression

=Sum( {<Status = {'A'}>} Amount)

jagan — Tue, 15 Mar 2016 01:12:55 GMT

Hi Donald,

Try like this using Set Analysis

=Sum( {<Status = {'A'}>} Amount)

Regards,

Jagan.

engishfaque — Tue, 15 Mar 2016 03:15:19 GMT

Dear Donald,

If you want to display Sum of Amount where Status = A then write down given below Expression in Text Object.

Expression:

=Sum ({<Status = {'A'}>} Amount) //Sum of Amount where Status = A

=Sum ({<Status = {'I'}>} Amount) //Sum of Amount where Status = I

=Sum ({<Status = {'A', 'I'}>} Amount) //Sum of Amount where Status = A, I

=Sum ({<Status -= {'I'}>} Amount) //Sum of Amount and Exclude Status = I

If you are making a chart, then Add Status as a Dimension and Add Expression such as given above.

Kind regards,

Ishfaque Ahmed

Tue, 15 Mar 2016 13:50:57 GMT

Awesome, thanks.