Qlikview chart Expression help

[miranrai]

Hi,

I need to build a straight table showing SAP/NON SAP submissions and non submissions for all companies.

Tables ledger, purchase and sales both contain sap and non sap data and SAP_Flag as identification for it. Company table holds all company details (There are 6 companies which are purely non sap, 2 companies submit both sap and non sap data and rest others are sap companies. ).

So matrix for this requirement is as below. My issue is how to calculate total number of companies which has done submission and non submission for SAP and NON SAP.

Thank you for your help in advance.

COMPANY_CODE	SAP/NONSAP	LEDGER	PURCHASE	SALES
0001	NON SAP	X	X
0002	NON SAP		X
0003	BOTH	X		X
0004	NON SAP
0005	BOTH	X	X	X
0006	NON SAP
0007	SAP	X	X	X
0008	SAP	X	X	X
0009	SAP
0010	SAP
0011	NON SAP
0012	SAP	X	X
0013	SAP	X	X
0014	NON SAP	X		X
0015	SAP	X	X	X
0016	SAP
0017	SAP
0018	SAP	X	X

Chart should show below figures.

For SAP
Total submission	Non submissions
xxx	xxx

[hariprasadqv]

Hi,

Use set analysis and count in it. like count({<SAP/NONSAP='NON SAP'>}[COMPANY_CODE]).

The above set expression will count number of companies with 'NON SAP', similarly for SAP also.

I think it will help you some how.

[sujeetsingh]

Not Clear what exactly you need.