Pivot Table

upaliwije — Sat, 29 Mar 2014 06:27:22 GMT

I have created a pivot table and I have extracted following report from it

RISK_YEAR	2011			2012			2013
Item N0	Sales	Nos	Paid	Sales	Nos	Paid	Sales	Nos	Paid
18	-	-	-	-	-	-	47,979	1	188,875
19	17,489	1	100,390	-	-	-	-	-	-
20	-	-	-	-	-	-	43,924	1	16,650
21	-	-	-	-	-	-	17,597	1	27,531
22	-	-	-	12,578	1	1,400	-	-	-
23	65,777	2	138,982	-	-	-	-	-	-
24	63,554	1	22,500	63,554	2	36,100	63,554	3	28,500
25	-	-	-	-	-	-	26,805	1	6,200
26	-	-	-	62,255	1	12,500	-	-	-
27	9,870	1	14,500	-	-	-	-	-	-
28	-	-	-	-	-	-	35,788	1	72,900
29	34,399	2	295,100	-	-	-	-	-	-
30	-	-	-	8,955	1	20,000	-	-	-
31	-	-	-	10,703	1	11,688	-	-	-
32	-	-	-	-	-	-	37,475	1	8,100
33	-	-	-	15,209	1	16,200	15,209	1	23,250
34	-	-	-	22,334	1	63,637	-	-	-
35	19,964	2	28,000	-	-	-	22,274	1	31,000
36	14,659	1	91,050	-	-	-	-	-	-
37	-	-	-	-	-	-	38,324	1	39,500
38	-	-	-	-	1	22,000	-	-	-
39	-	-	-	-	-	-	59,711	1	10,770
40	-	-	-	-	-	-	115,730	3	28,000
41	10,596	1	4,800	-	-	-	-	-	-
42	-	-	-	-	1	37,000	-	1	29,800
43	55,108	1	8,000	51,108	4	21,833	51,108	1	80,396

To extract above report I have written following expression

only(SALES)

count(DISTINCT(Nos))

sum( PAID_AMOUNT )

Now I want to write an expression to return records which are highlighted above Row No 24 and 43. In other words records where Nos appear in all three years 2011,2012 and 2013

Pls help me

Re: Pivot Table

its_anandrjs — Sat, 29 Mar 2014 08:32:12 GMT

You can use like a calculated Dimension

Dimension [Item N0] =if((sum(Sales) And sum(Paid) And sum(Nos)) > 0,[Item N0])

Hope this helps

Thanks & Regards

topic Pivot Table in QlikView

Pivot Table

Re: Pivot Table