Unconditional value in Set Analysis

[#1]

Hello, is it possible to get an 'X'  for all customers in [CustomerGroup]= "13"  without fullfilling   [DebPris]/100)>=30000 ?

if(Sum({$<$(vSetRolling12),[Segment]={"Glas"},[CustomerGroup]={"*"} - {"02","04","07","10","11","14","16","17","18","19","20","50","29"}>} [DebPris]/100)>=30000,'X','')

Håkan

[swuehl · Accepted solution]

Maybe like

if(Sum({$<$(vSetRolling12),[Segment]={"Glas"},[CustomerGroup]={"*"} - {"02","04","07","10","11","14","16","17","18","19","20","50","29"}>} [DebPris]/100)>=30000

OR Sum({<[CustomerGroup]={13} >} 1)

,'X','')

[#3]

Hello again,

when I test this in version 11 it works fine but not in version 12, I get 'Errors in expression,

also with my original expression without the 'OR'-sentence. Is the Set  Analysis changed ?

Håkan

[sunny_talwar]

Is the Expression editor saying that there is any error or are you not seeing the right result? This might be a case where expression editor might be having a difficult time interpreting your variable within the set analysis. Also check if the variable is the same in both the versions of QV you are using to evaluate this

[swuehl]

I don't think the set analysis changed. But AFAIK, the syntax checker has changed.

I assume what you see is just a false alarm of the checker due to the dollar sign expansion.

What if you just press OK and see if returns the correct result?

[#6]

Yes it works eventhough it says erro. I have to live with this.

Thanks for all help and quick response.

kindly

Håkan