"Greater than" operator in data messing up if-logic

[#1]

Hello Fellow Qlikviewers,

Here's a simple question: how can I fix the following formula, where I have the value ">5%" in my dataset.

count(if(Revenue = '>5%' ,Client))

Having the "greater than" operator in my dataset is probably the cause of this issue. 

Any help will be greatly appreciated.

[swuehl]

Not sure if I understand, seems to work for me.

Could you upload a small sample QVW that demonstrates your issue?

[#3]

Hi,

The formula does not generate an error message, but the result is 0 when it should be more than that.

Thanks.

[kuczynska]

What is the format of Revenue field? As Swuehl mentioned before me, can you upload a sample qvw?

If your Revenue field is in text format in the load script, you can always try to use combination of replace() and num() functions to bring it back to the numerical format, which should be way easier and faster to use in the frontend.

Did you try to change your expression to:

if(Revenue = '>5%' , count(Client) )

[#5]

Below is what the dataset looks like.

count(if(Revenue='>5%', Client))

I would expect this formula to come up with a value of 2, but it's coming out as 0.

Any ideas?  Thanks

Client	Revenue
ABC	>5%
DEF	0%to5%
GHI	0%to-10%
JKL	<-10%
MNO	>5%
PQR	0%to5%

[swuehl]

Is Revenue really a field in your data model or an expression in a chart?

Could you post a small sample QVW that demonstrates your issue?

Have you checked that the value does not contain additional characters, like spaces?

[qlikviewwizard]

Hi Trung,

Please attach the sample application to demonstrate your issue.Thank you.