Section Analysis to count rows with a null field value

Fri, 07 Nov 2014 23:07:30 GMT

I have a table with Application Data. Each application may or may not have one or many tracking records associated with the application number. If the tracking record exists, it will have a value for all of the fields in the tracking record table; if the Application has no tracking record(s), all tracking record fields will be null. How do I use set analysis to both count number of apps with a null tracking record as well as count and sum the apps with the tracking record? See Sample Data (Application # is the only field that comes from the Application Table)

Application #	TR Created Date	TR Locator	TR Refi Status	TR Refi Status User	TR Credit Lender	TR Credit Loan Type	TR Credit Curr. Balance	TR Refi Credit Limit	TR Refi. Int. Rate	TR Refi. Savings
14895	-	-	-	-	-	-	-	-	-
584789	10/17/2014	305	New Offer	Joe Smith	Chase Bank	Mortgage	258,412	275,000	4.59	520.00
54125	10/24/2014	135	Accepted	Kari Williams	AMEX	Credit Card	7,568.00	10,000	2.99	87.00
42589	10/30/2014	206	No Savings	Carl Fitz	Red Rocks CU	LOC	500	500	7.59	0.00
658	-	-	-	-	-	-	-	-	-	-
25984	10/16/2014	584	New Offer	Joe Smith	US Bank	Credit Card	2698.	5000.00	8.99	29.00
3652	10/2/2014	102	New Offer	Susan George	Wells Fargo	Credit Card	1595.00	2500.00	8.99	45.00
8549	-	-	-	-	-	-	-	-	-	-
15987	10/5/2014	103	Ask Later	Kari Williams	Bellco CU	LOC	2693.00	5000.00	7.59	94.00
15987	10/5/2014	104	Ask Later	Kari Williams	Bellco CU	HELOC	45,627.00	60,000	4.19	138.00
15987	10/5/2014	105	Ask Later	Kari Williams	GM	Auto	19,545.00	20,000.00	1.95	32.00
68741	-	-	-	-	-	-	-	-	-	-

Re: Section Analysis to count rows with a null field value

ashfaq_haseeb — Sun, 09 Nov 2014 06:56:17 GMT

Hi,

May be like this.

Have a look at attached application.

Regards

ASHFAQ

Re: Section Analysis to count rows with a null field value

danieloberbilli — Sun, 09 Nov 2014 07:20:52 GMT

Please find .qvw with examples of If-statement as well as set analysis solution attached.

topic Section Analysis to count rows with a null field value in QlikView

Section Analysis to count rows with a null field value

Re: Section Analysis to count rows with a null field value

Re: Section Analysis to count rows with a null field value