topic Removing 0 Value Contents in QlikView

Removing 0 Value Contents

Thu, 18 Aug 2011 10:59:25 GMT

I have below table showing Invoice data.

Invoice NO	Invoice Date	Part NO	Qty	Price	Invoice Due Date	PAID?
5702021	10/04/2011	Part 001	10	€ 10.00	31/05/2011	YES
5702021	10/04/2011	Part 002	5	€ 100.00	31/05/2011	YES
5702023	25/04/2011	Part 003	5	€ 80.00	30/06/2011	NO
5702023	25/04/2011	Part 004	10	€ 70.00	30/06/2011	NO
5702025	10/05/2011	Part 005	5	€ 30.00	30/06/2011	NO
5702025	10/05/2011	Part 006	15	€ 20.00	30/06/2011	NO
5702025	10/05/2011	Part 007	20	€ 25.00	30/06/2011	NO
5702025	10/05/2011	Part 008	25	€ 15.00	30/06/2011	NO
5702029	28/07/2011	Part 009	30	€ 10.00	31/08/2011	YES
5702029	28/07/2011	Part 010	30	€ 10.00	31/08/2011	YES
5702030	15/08/2011	Part 011	10	€ 10.00	30/09/2011	NO
5702030	15/08/2011	Part 012	10	€ 15.00	30/09/2011	NO
5702030	15/08/2011	Part 013	10	€ 20.00	30/09/2011	NO

Based on this table, let me have code to get unpaid invoice data (shown below)

UNPAID Invoice	Invoice Date	Invoice Due Date	VALUE
5702023	25/04/2011	30/06/2011	€ 1,100.00
5702025	10/05/2011	30/06/2011	€ 1,325.00
5702030	15/08/2011	30/09/2011	€ 450.00
€ 2,875.00

Removing 0 Value Contents

Thu, 18 Aug 2011 11:17:05 GMT

€2875.00 is total unpaid inovice value...

Removing 0 Value Contents

Thu, 18 Aug 2011 11:38:52 GMT

Hi,

Try to create a straight table with the following dimensions. 'Invoice NO', 'Invoice Date', 'Invoice Due Date'..... and include the following expression:

sum({< PAID={"YES"}>} Price).

Regards

Removing 0 Value Contents

swuehl — Thu, 18 Aug 2011 11:44:59 GMT

I think the expression should be like

= sum({<[PAID?]={'NO'}>} Qty*Price)

with dimensions like stated by biteguebiessono.

Regards,

Stefan

Removing 0 Value Contents

Thu, 18 Aug 2011 11:57:11 GMT

oooh yeah, it's supposed to be PAID= 'NO'

Removing 0 Value Contents

Thu, 18 Aug 2011 11:59:39 GMT

Thansk. it's working..