Top x% of values

[#1]

Hi,

I have a straight table as below, where ID, Name and Score are dimensions.

How do i:

1. Create an expression where, i can extract the scores more than 45 marks?

2. Create an expression where, only the top 70% is visible?

thanks!

<Dimension>	<Dimension>	<Dimension>	<Expression>
ID	Name	Score	If(match(score, >45), score, NULL()) Top 70% visible?
1	A	100	100
2	B	99	99
3	C	98	98
4	D	97	97
5	E	96	96
6	F	45	(Hidden)
7	G	42	(Hidden)

[sujeetsingh]

On expression Use Conditional option and Write the condition you want.

Or the one i used in the sample below

[Gysbert_Wassenaar]

if(score>45,score) should work as expression. If you're using QV11 you can use dimension limits to show the top 70%. You can configure this on the Dimension Limits tab of the properties window by selecting the third option and choose 70% relative to the total.

[#4]

Yes, i am V11.

How do i do in condition?

Under Dimension Limits Tab

score -> restrict which values are displayed using the first expression

Show only values that are:

less than or equal to 70% relative to the total?

But it does nto seem to work?

Sorry if the question might be quite basic.

[#5]

Thanks much!

Possible to copy and paste the condition in text?

[#6]

For the %, still does not seem to work... i guess i will stick with the absolute score then...

Let me know if there are other ways?

[Gysbert_Wassenaar]

See attached example.

[#8]

Possible to copy and paste the steps in text?

sorry.