Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

belias1980
New Contributor II

Set Analysis Question - Bring in Data for Null Value

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 RepSecondMonthBillReasonDidNotBill
43431Joe Smith05/01/2017-
52310Don Smith-Sales Rep did not follow up
32104Lulu Smith06/01/2017-
44187Joe Montana02/04/2017-
14356Brett favre-Sales Rep left the team

Thanks!

2 Replies

Re: Set Analysis Question - Bring in Data for Null Value

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

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

belias1980
New Contributor II

Re: Set Analysis Question - Bring in Data for Null Value

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

Community Browser