Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with first dimension - pivot

Hi All!

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

lets say I have the following table:

IDIs Main ActivityParent ID
1YesNull
2No1
3No1
4YesNull
5No4

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.

2 Replies
Anonymous
Not applicable
Author

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.

reshmakala
Creator III
Creator III

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.