topic Re: Unconditional value in Set Analysis in QlikView

Unconditional value in Set Analysis

Tue, 07 Jun 2016 10:04:19 GMT

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

Re: Unconditional value in Set Analysis

swuehl — Tue, 07 Jun 2016 10:10:38 GMT

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','')

Re: Unconditional value in Set Analysis

Tue, 07 Jun 2016 11:39:17 GMT

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

Re: Unconditional value in Set Analysis

sunny_talwar — Tue, 07 Jun 2016 11:43:20 GMT

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

Re: Unconditional value in Set Analysis

swuehl — Tue, 07 Jun 2016 11:43:30 GMT

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?

Re: Unconditional value in Set Analysis

Tue, 07 Jun 2016 11:53:13 GMT

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

Thanks for all help and quick response.

kindly

Håkan