I have a Qlikview Application I am working on and am having difficulty with a couple formulas / functions.
1. In the attached application, I have a Expression Target Company that uses an Alternative State. All Other Expressions do not. How do I adjust the Table to only display Categories without a Null Value or Zero?
2. I can't figure out how to write a formula that will define what Percentile the Target Compay falls into (i.e. 10th, 25th.......>95th). I have set up an Expression field for this formula. In addition, I would like to setup Conditional formatting to highlight in yellow the Percentile the Target Company fall into.