topic Re: Set Analysis ">" Text in QlikView

Set Analysis ">" Text

Mon, 04 Apr 2016 03:50:09 GMT

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)

Re: Set Analysis ">" Text

Chanty4u — Mon, 04 Apr 2016 06:33:43 GMT

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

//]

//;

Re: Set Analysis ">" Text

arulsettu — Mon, 04 Apr 2016 06:43:29 GMT

for this what result getting

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

can you post the sample qvw

Re: Set Analysis ">" Text

marcus_sommer — Mon, 04 Apr 2016 11:48:10 GMT

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

- Marcus

Re: Set Analysis ">" Text

sunny_talwar — Mon, 04 Apr 2016 12:10:22 GMT

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)

Re: Set Analysis ">" Text

Anonymous — Mon, 04 Apr 2016 12:20:54 GMT

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

Re: Set Analysis ">" Text

Kushal_Chawda — Mon, 04 Apr 2016 12:21:48 GMT

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)

Re: Set Analysis ">" Text

Anonymous — Mon, 04 Apr 2016 12:37:25 GMT

You missed closing curly braces

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

Re: Set Analysis ">" Text

Tue, 05 Apr 2016 01:27:29 GMT

Thanks Marcus... this works!