Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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.

Tags (1)
9 Replies
Not applicable

Re: 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.

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

srikanthsri1
Valued Contributor

Re: 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.

use calculated dimension ;

if(field =1 ,1)

and check supress null values

hope it helps

Sri1

Not applicable

Re: 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.

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

Not applicable

Re: 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.

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

Empty cell? or maybe '-'?

Not applicable

Re: 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.

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

Re: 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.

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

Not applicable

Re: 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.

Use calculated dimension with following

If(field=1,field)

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

Not applicable

Re: 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 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

Re: 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.

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

Community Browser