Set Analysis ">" Text

[#1]

Hi all,

I have a field that contain text value such as "1", "2", "3", ">3". I want to filter the data using set analysis. But the problem is that set analysis treats the ">3" as "more than 3" than text value ">3". Is there a way to

For example, I want to filter my data to [Age Group]=">3".

sum({$<[Age Group]={'>3'}> Amount)

[Chanty4u]

hi

u can create in script  flags as below

//AgingWeekSort:

//mapping load * Inline

//[ Defect_Aging_Weeks,Value

//1 Week,1

//2 Weeks, 2

//> 2 Weeks,3

//]

//;

//

//AgingDaysSort:

//Mapping LOAD * Inline

//[Defect_Aging_DayBands, Value1

//1 Day, 1

//2 Days, 2

//3 Days, 3

//> 3 Days, 4

//]

//;

[arulsettu]

for this what result getting

sum({$<[Age Group]={'>3'}> Amount)

can you post the sample qvw

[marcus_sommer · Accepted solution]

What happens by: sum({$<[Age Group]={'*>3'}> Amount) ?

- Marcus

[sunny_talwar]

Not sure why, but your expression seems to work for me:

Just make sure not to miss the last missing curly bracket

=Sum({$<[Age Group]={'>3'}>} Amount)

[Anonymous]

HI,

You should try:

sum({<[Age Group]={"> 3"}>} Amount)

with a space between > and 3 if in your datas it is written so.

Otherwise as said by Sunny, it seems to be working when you write exactly the same thing as your datas in the set

[Kushal_Chawda]

if you are using the correct field then filtering the value of that field will not be the issue

This should work

=sum({$<[Age Group]={">3"}>} Amount)

[Anonymous]

You missed closing curly braces

sum({$<[Age Group]={'>3'}>} Amount)

[#9]

Thanks Marcus... this works!