Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I have a column in my pivot table that has been set up to display either a 0 or 1. How can I get the table to display only records where this column is 1? I tried using an if statement as a condition on the layout tab but it didn't work.

I have a column in my pivot table that has been set up to display either a 0 or 1. How can I get the table to display only records where this column is 1? I tried using an if statement as a condition on the layout tab but it didn't work.

9 Replies
Not applicable
Author

You may try with Set Analysis.

There is also checkbox on Presentation tab:

Suppress Zero-ValuesThis check box eliminates columns or rows that contain only zeros from the table.

regards

Darek

Anonymous
Not applicable
Author

use calculated dimension ;

if(field =1 ,1)

and check supress null values

hope it helps

Sri1

Not applicable
Author

Suppress Zero didn't seem to work. Have all the variables in that record have to be 0 for that to work?

Not applicable
Author

If all row should be presented what you would like to show instead 0?

Empty cell? or maybe '-'?

Not applicable
Author

Maybe my post is a little confusing. I want to eliminate any row that has a 0 in this certain field. Right now I'm showing 14 rows. 7 have a 1 in this particular field and 7 have a 0. I only want to show the rows where this field = 1.

Not applicable
Author

Please share your application. This will be easiest way to help.

Not applicable
Author

Use calculated dimension with following

If(field=1,field)

Select "Suppress When Value Is Null" option for this dimension.

Not applicable
Author

I only want data to display if 'Chng>Std Dev' has a 1 in it.

Here’s the expression for ‘Chng>Std Dev’

If(fabs(Column(4))>=Column(3),1,0)

Not applicable
Author

Am I suppose to put my column name in place of 'field'?