topic Re: Hiding rows in straight table in QlikView

Hiding rows in straight table

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Hiding rows in straight table

sunny_talwar — Thu, 10 Mar 2016 20:04:02 GMT

Try calculated dimension for Status:

=If(Status = 'Active', Status)

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

Re: Hiding rows in straight table

amayuresh — Fri, 11 Mar 2016 03:29:42 GMT

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

Re: Hiding rows in straight table

jagan — Fri, 11 Mar 2016 03:43:08 GMT

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.

Re: Hiding rows in straight table

amit_saini — Fri, 11 Mar 2016 04:17:08 GMT

Hi,

See the attachment.

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

And checked 'Suppress When Value Is Null' option.

Thanks,

Re: Hiding rows in straight table

tamilarasu — Fri, 11 Mar 2016 04:21:26 GMT

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

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

Re: Hiding rows in straight table

Anonymous — Fri, 11 Mar 2016 05:23:48 GMT

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

Re: Hiding rows in straight table

awhitfield — Fri, 11 Mar 2016 11:40:32 GMT

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