Problem in Pivot table and set analysis

[viveksairam89]

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

Scenario:

This should contain Field2 like Telephone, Mobile, TAB only

( For TAB, we need to exclude Field1 = C) only,
For (Telephone, Mobile) Field1 C should be displayed. in single table all this scenario's

I have attached QVW File

[sunny_talwar]

May be this:

Sum({$-<Field2 = {'I Pod'}>-<Field1 = {'Tab'}, Field1 = {'C'}>}Field3)

[viveksairam89]

In my scenario Field C has Telephone and mobile ,So that should display

[sunny_talwar]

So is this not what you are seeing?

[Anonymous]

Hi viviek, try this: sum({<Field2=E({<Field1={'C'}, Field2={'Tab'}>} Field2)>}Field3)

[viveksairam89]

Hi Manuel Capella,

Thanks for the reply

Your expression is working fine partially, When I added in inline for field1 additionally (Tab) to field2,this expression is not working out for this condition, QVW attached

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

[viveksairam89]

Hi Sunny,

Thanks for your reply

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

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

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

[Anonymous]

Hi Viviek,

Try this too:

Add a field concatenating field1 and field2:

LEFT JOIN

LOAD

    Field1,

    Field2,

    Field1&'-'&Field2 as ExcludeField

RESIDENT YourTable;

On chart:

sum({<ExcludeField-={'C-Tab'}>}Field3)

Regards!!!!