Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
miranrai
New Contributor III

Qlikview chart Expression help

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_CODESAP/NONSAPLEDGERPURCHASESALES
0001NON SAPXX
0002NON SAP X
0003BOTHX X
0004NON SAP
0005BOTHXXX
0006NON SAP
0007SAPXXX
0008SAPXXX
0009SAP
0010SAP
0011NON SAP
0012SAPXX
0013SAPXX
0014NON SAPX X
0015SAPXXX
0016SAP
0017SAP
0018SAPXX

Chart should show below figures.

For SAP
Total submissionNon submissions
xxxxxx

Tags (1)
2 Replies
hariprasadqv
Contributor III

Re: Qlikview chart Expression help

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
Honored Contributor III

Re: Qlikview chart Expression help

Not Clear what exactly you need.