topic Re: Hide row in straight table in QlikView

Hide row in straight table

engishfaque — Wed, 28 Jan 2015 17:47:53 GMT

Dear All,

How to hide/remove row from the straight table, such as illustrated in attached screenshot.

Kind regards,

Ishfaque Ahmed

Re: Hide row in straight table

sunny_talwar — Wed, 28 Jan 2015 17:49:48 GMT

If SKU is your dimension then you can write something like this:

If(Makeup <> 'Set', SKU)

and then change the Label to SKU

If there is another way you want to hide then use that condition in the dimension.

Best,

Re: Hide row in straight table

sujeetsingh — Wed, 28 Jan 2015 17:53:41 GMT

You can use the Calculated dimension as

if(Dimensio<>'Value to be hidden',Dimension,null())

And then supress null for dimension.

Re: Hide row in straight table

its_anandrjs — Wed, 28 Jan 2015 17:55:15 GMT

Hi,

Did you try Suppress When Value is NULL option from the chart properties for suppress particular value from the column by selecting that column.

Regards

Anand

Re: Hide row in straight table

NickHoff — Wed, 28 Jan 2015 18:00:07 GMT

Suppress When Value is NULL won't work because the value isn't truly NULL with Makeup as 'Set'

Re: Hide row in straight table

engishfaque — Wed, 28 Jan 2015 18:01:42 GMT

Dear Anand,

The value is coming correct in Makeup = Set and I'm adding the value of Set in some other expressions.

But here only, I want to hide entire row of Makeup = Set.

I'm not going to disturb any expression where the value of Set is used.

Kind regards,

Ishfaque Ahmed

Re: Hide row in straight table

engishfaque — Wed, 28 Jan 2015 18:07:24 GMT

Dear Anand,

Here is my requirement in simple words,

if(Makeup = 'Set', Entire Row Should be hide, SKU)

Kind regards,

Ishfaque Ahmed

Re: Hide row in straight table

engishfaque — Wed, 28 Jan 2015 18:25:39 GMT

Dear All,

I'm still facing an issue.

Kind regards,

Ishfaque Ahmed

Re: Hide row in straight table

sunny_talwar — Wed, 28 Jan 2015 18:27:36 GMT

Did you try this?

If(Makeup <> 'Set', SKU)

Best,

Re: Hide row in straight table

Anonymous — Wed, 28 Jan 2015 19:17:25 GMT

In my opinion, sujeetsingh's answer is correct!

=IF(Makeup<>'Set', SKU, null()) and then flag option Suppress When Value is null.

Try it.

Let us know!