Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
rsdhavle
Creator II
Creator II

Restricting all other columns based on condition on one

Hi,

I have columns lets say A,B,C,D all have different expressions. my  C column has values 10%,20%, 30%..so on. I need to show data in the completed table only if value on My C column is more than 20%. For example lets say a value in a C column is 10% then that row should disappear irrespective of values in other columns of the table. What is the approach to do so?

4 Replies
swuehl
MVP
MVP

I think you need to add a condition to your other columns, checking the result of your column C:

=if( "C" > 0.2, YOUROTHEREXPRESSION,0)

rsdhavle
Creator II
Creator II
Author

will that disappear row from the table or will show blank value in a column?

swuehl
MVP
MVP

If you enable the option 'Suppress zero values' on presentation tab and if you add a similar condition to all your columns (except C, of course), the row should disappear.

ashishkalia
Partner
Partner

Bro u can use  if( "C" > 0.2, calculated dimension/dimension,0) at the primary dimension.
in that case the dimension will be disabled nd hence the complete row will be dissipated.

cheers.......