Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
1) may be use like this {<ReasonDidNotBill = {"*"}>}
2) Make sure you have unchecked 'Include null values' under your dimension
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