Solved: Need to show row when X present others rows need t... - Qlik Community - 1315861

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services| Qlik Help |

Ask a Question

Hi All,

PFA.

When 'X' present in any row I need to show whole that row other rows no need to show.Please suggest

Thanks

44 KB

1 Solution

Accepted Solutions

Assuming X is in column 1, then use a condition on each expression like

If(Column(1) = 'X', <original expression for column2>)

If(Column(1) = 'X', <original expression for column3>)

...

Then ensure that suppress zeros and nulls is enabled

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

2 Replies

Assuming X is in column 1, then use a condition on each expression like

If(Column(1) = 'X', <original expression for column2>)

If(Column(1) = 'X', <original expression for column3>)

...

Then ensure that suppress zeros and nulls is enabled

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Author

Thanks Jonathan.

Its working