topic Re: Problem with first dimension - pivot in QlikView

Problem with first dimension - pivot

Tue, 13 Jan 2015 15:13:51 GMT

Hi All!

I'm having a problem while creating a pivot table.

lets say I have the following table:

ID	Is Main Activity	Parent ID
1	Yes	Null
2	No	1
3	No	1
4	Yes	Null
5	No	4

I have Hierarchy Pivot table. The firs Dimension Is the ID (Lets Say "1").I want that the condition will be (if (Is Main Activity=Yes, Parent ID)),

The Next Dimensions contains all the children of 1 (2,3). the problem is that they have "Is main Activity = No" so they are not display on the pivot table.

Does someone have any idea of how to fix this?

Thanks.

Re: Problem with first dimension - pivot

Anonymous — Tue, 13 Jan 2015 20:10:56 GMT

Hi Michal,

I don't undestand where you want to insert the condition (if (Is Main Activity=Yes, Parent ID)).

Can you post your expected output?

Thanks.

Re: Problem with first dimension - pivot

reshmakala — Tue, 13 Jan 2015 20:33:06 GMT

Your if statement (if (Is Main Activity=Yes, Parent ID)) is just a if-then statement so you cannot see the rows not satisfying the condition. Put some else condition to see those rows.