topic Re: Set Analysis. Field is not equal other field. in QlikView

Set Analysis. Field is not equal other field.

maxsheva — Tue, 11 Jul 2017 08:07:12 GMT

Hi,

How can I replace expression below with set analysis?

if(Field1=Field2, 0, Sum(Value))

I tried different variants. For example this one doesn't work as well.

Sum({$<Field1-=Field2>} Value)

Re: Set Analysis. Field is not equal other field.

Anil_Babu_Samineni — Tue, 11 Jul 2017 08:09:29 GMT

Better to use in script like

If(Field1 <> Field2 , 1, 0) as Flag

And set analysis

Sum({<Flag = {'1'}>}Value)

Re: Set Analysis. Field is not equal other field.

ahaahaaha — Tue, 11 Jul 2017 08:33:32 GMT

Try

=Sum({<Field1={"=Field1<>Field2"}>}Value)

Re: Set Analysis. Field is not equal other field.

antoniotiman — Tue, 11 Jul 2017 08:34:25 GMT

Hi Max,

Set Analysis is calculated per Chart and You need per Rows.

Sum(If(Field1=Field2,0,Value))

However Sintax Set Analysis is like this

Sum({<Field1-={'$(=Max(Field2))'}>} Value)

or like this

Sum({<Field1=E(Field2)>} Value)

Regards,

Antonio

Re: Set Analysis. Field is not equal other field.

maxsheva — Tue, 11 Jul 2017 08:53:41 GMT

Thanks but all versions of set analysis don't show an expected result.

I can't use flag in script according to current data model.

Please look at the attachment qvw

First chart shows correct result with IF statement.

Other ones with all set analysis variants above. They show different.

Re: Set Analysis. Field is not equal other field.

antoniotiman — Tue, 11 Jul 2017 09:05:11 GMT

In this case the Expression must be evaluated per row, then You need If() instead of Set Analysis.

Re: Set Analysis. Field is not equal other field.

ahaahaaha — Tue, 11 Jul 2017 09:12:47 GMT

May be

Sum({<Field2={"=Field1<>Field2"}>}Value)

Re: Set Analysis. Field is not equal other field.

avinashelite — Tue, 11 Jul 2017 09:14:19 GMT

If its a row to row comparison then I would prefer to have it in the script level .....in the front end it will take lot of time to evaluate and render

Re: Set Analysis. Field is not equal other field.

maxsheva — Tue, 11 Jul 2017 09:42:32 GMT

Thanks all and especially Andrey.

to avinashelite

I have created matrix where all values in field1 are equals to all values in field2. Let's say field2 is duplicate from field1.

How can I create flag in script in this case?

Re: Set Analysis. Field is not equal other field.

avinashelite — Tue, 11 Jul 2017 09:52:44 GMT

if you share the sample data set we could help you out..create a separate thread

Re: Set Analysis. Field is not equal other field.

Anil_Babu_Samineni — Tue, 11 Jul 2017 09:55:19 GMT

FYI - I don't prefer to use direct set analysis. Because, Recently i had faced and took big challenge when this project on live. When i use that expression i am getting triple of the records like if i have script used like i mentioned it showing as expected but when i use Set analysis direct it consume triple like 3x. I wonder, That time that is cause some triggering issue i feel. Any how - You got the output. That's good