Set Analysis Question - Bring in Data for Null Value

[Anonymous]

Hi,

First of all - you guys are all awesome, I appreciate any help i get!

Back story: I have a view that pulls all the sales for the company, the commission is based on whether the product gets billed for two months. So we have a field that pulls in the second month("SecondMonthBill") bill date to show a commission for that account. The column is null if they didn't convert that account to a second month bill.The management would like to see who didn't convert that account, so we pulled in the "ReasonDidNotBill"

Problems:

(1)How can i run analysis that just shows all the non second month into a sheet.

(2)excluding dates on second month bill.I'd like to use a pie chart and bring in all the "ReasonDidNotBill" but when i do, it brings in "-" undefined.

If there is an easy way to solve this that would be awesome.

Data Example:

Account#	Sales Rep	SecondMonthBill	ReasonDidNotBill
43431	Joe Smith	05/01/2017	-
52310	Don Smith	-	Sales Rep did not follow up
32104	Lulu Smith	06/01/2017	-
44187	Joe Montana	02/04/2017	-
14356	Brett favre	-	Sales Rep left the team

Thanks!

[sunny_talwar]

1) may be use like this {<ReasonDidNotBill = {"*"}>}

2) Make sure you have unchecked 'Include null values' under your dimension

[Anonymous]

Sunny - Thanks for the prompt response.

I was had it unchecked and I could not use {<ReasonDidNotBill = {"*"}>}

I even explored this awesome wizard:Set Analysis Wizard for QlikView | qlikblog.at

But still no luck