Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
New Contributor II

Alternate State and Percentiles

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.

Let me know, if and how this can be done.

Thanks in advance for your help.


1 Solution

Accepted Solutions

Re: Alternate State and Percentiles

4 Replies

Re: Alternate State and Percentiles

See if my replying will kick this back up to see if someone may be able to help given you attached a qvw file etc.  The only thing I could really do on this one is point you to the Help:


Hopefully that might help to a degree in the meantime, hopefully someone else with better development skills may be able to have a look and give you some further pointers here.


To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

Re: Alternate State and Percentiles


Re: Alternate State and Percentiles

Could you please put the code you used for this in the group - I can't seem to download the qvw file and I have a very similar issue

Re: Alternate State and Percentiles

For the percentile calculation, I used this

If(Len(Trim(Column(2))) > 0,
	If(Column(2) <= Column(6), '10th',
		If(Column(2) <= Column(7), '25th',
			If(Column(2) <= Column(8), '40th',
				If(Column(2) <= Column(9), '50th',
					If(Column(2) <= Column(10), '60th',
						If(Column(2) <= Column(11), '75th',
							If(Column(2) <= Column(12), '80th',
								If(Column(2) <= Column(13), '85th',
									If(Column(2) <= Column(14), '90th',
										If(Column(2) <= Column(15), '95th', '>95th'))))))))))


For removing additional rows, I used the following if statement for all expressions expect the second one

If(Len(Trim(Column(2))) > 0, ...)