Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
sqlpuzzle
Contributor III
Contributor III

Filter rows in Pivot Table

Hi ,

 

I have a sample attached. I need to filter rows in the Pivot table when "#One" = "#Two".

I want to see only rows when "#One" & "#Two" are not equal.

How to do this?

 

1 Reply
Marcos_Ferreira_dos_Santos

Hi Sqlpuzzle ?

Have you solved this puzzle ?   I hope so.

A piece of advice would be to treat it in script/load time, whether by loading only the not equal, or by filling a calc dim "Equal" with Yes/No.

Best regards,

Marcos