topic Set analysis expression error in QlikView

Set analysis expression error

viveksairam89 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am unable to write this condition in the expression and calculated dimension, I have field1,2,3

Field1 and 2 are the dimensions

Field3 is the expression

Conditions and scenario:

if Tab in Field1 A is found it should be displayed
For (Telephone, Mobile) in Field1 C is found it should be displayed.

If field2=Tab in Field1 C is found then it should not display

Expression Used:
sum({<Field2=E({<Field1={'C'}, Field2={'Tab'}>} Field2)>}Field3)

LOAD * INLINE [
Field1, Field2, Field3
A, Telephone, 5
A, Tab, 5
B, Mobile, 10
C, Tab, 20
C, Telephone, 30
D, I Pod, 25

In Field1 A = Tab missing in the metrics

So can you kindly help me this to fix

sunny_talwar — Fri, 12 Aug 2016 14:09:46 GMT

Try this:

Sum({<Key = E({<Field1={'C'}, Field2={'Tab'}>} Key)>}Field3)

Where Key is created like this in the script:

LOAD *,

AutoNumber(Field1&Field2) as Key;

LOAD * INLINE [

Field1, Field2, Field3

A, Telephone, 5

A, Tab, 5

B, Mobile, 10

C, Tab, 20

C, Telephone, 30

D, I Pod, 25

];

stigchel — Fri, 12 Aug 2016 14:27:34 GMT

Or alternatively use

sum({1-<Field1={'C'},Field2={'Tab'}>} Field3)

viveksairam89 — Fri, 12 Aug 2016 18:59:20 GMT

Thanks Sunny and Piet Hein van der stigchel for you response

Regards

SM.Vivek