Hiding rows in straight table

[#1]

Hi

I want to hide all rows when Status=Inactive. Please help

[sunny_talwar]

Try calculated dimension for Status:

=If(Status = 'Active', Status)

UPDATE: and make sure to select 'Suppress When Value Is Null'

[amayuresh]

Try this

1. Straight table with Dimension Name

2. Expression as =sum({<Status={'Active'}>}Age)

3. Uncheck Supress Zero-Values

4. Click Apply and Ok

[jagan]

Hi,

Try like this

Remove Status dimension and add below expression

=Only({<Status={'Active'}>} Status)

Note: Calculated dimensions are not good, you will get performance issues when the data is huge.  So better try to avoid it.

Regards,

jagan.

[amit_saini]

Hi,

See the attachment.

=if(Match(Status,'Active'),Status)

And checked 'Suppress When Value Is Null' option.

Thanks,

AS

[tamilarasu]

Instead of calculated dimension, you can change your expression as,

Only({<Sign={'KP'},Status={'Active'}>}Sign)

[Anonymous]

use calculated dimension...... as =if(Status='Active',Status) with Suppress when value is null...

[awhitfield]

Hi,

if you don't actually need the data with the INACTIVE Status, why load it?

You could try:

Data:

LOAD Name,

     Age,

     Basic,

     Perks,

     Bonus,

     Sign,

     Status

FROM

hidingrow.xlsx

(ooxml, embedded labels, table is Sheet1);

Data2:

Noconcatenate load *

Resident Data

where Status = 'Active';

Drop Table Data;

HTH

Andy