topic Re: Problem in Pivot table and set analysis in QlikView

Problem in Pivot table and set analysis

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

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

Re: Problem in Pivot table and set analysis

sunny_talwar — Thu, 11 Aug 2016 15:15:16 GMT

May be this:

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

Re: Problem in Pivot table and set analysis

viveksairam89 — Fri, 12 Aug 2016 06:00:43 GMT

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

Re: Problem in Pivot table and set analysis

sunny_talwar — Fri, 12 Aug 2016 09:48:11 GMT

So is this not what you are seeing?

Re: Problem in Pivot table and set analysis

Anonymous — Fri, 12 Aug 2016 10:09:07 GMT

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

Re: Problem in Pivot table and set analysis

viveksairam89 — Fri, 12 Aug 2016 10:48:36 GMT

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
];

Re: Problem in Pivot table and set analysis

viveksairam89 — Fri, 12 Aug 2016 10:54:46 GMT

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
];

Re: Problem in Pivot table and set analysis

Anonymous — Tue, 16 Aug 2016 06:17:18 GMT

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!!!!