topic Re: How to enable conditional value for a record to hide in a Column field in QlikView

How to enable conditional value for a record to hide in a Column field

Anonymous — Fri, 12 Jun 2015 08:50:58 GMT

Hi,

I have one small doubt. How can I set a condition for a field in Column.

I have below data in a Straight table and I want to hide or set to null the records "Sales" in column "Department Type".

I tried functions Match, GetSelecFields and Set Analysis but unable to solve this issue.

Can anyone help me?

"Date" "Category" "Department Type" "Employee"

1 IT Software A

2 NonIT Sales B

3 NonIT Sales C

4 IT Software D

5 IT Software E

I do not want to see Sales in Department Type column and result should be either 0 or Null.

Thanks,

Shiva.

Re: How to enable conditional value for a record to hide in a Column field

Fri, 12 Jun 2015 08:52:54 GMT

if(Department Type = 'Sales', NULL(), Department Type)

Try this in dimension...

Re: How to enable conditional value for a record to hide in a Column field

alexandros17 — Fri, 12 Jun 2015 09:06:40 GMT

I think that Department Type is a dimension so:

If you need to hide the Whole row containing "Sales" then write (as dimension)

If([Department Type]='Sales', Null(), [Department Type])

Check the box "Suppress when value is null"

Let me know

Re: How to enable conditional value for a record to hide in a Column field

awhitfield — Fri, 12 Jun 2015 09:11:44 GMT

Hi Shiva,

replace the Department Type Dimension with a calculates one:

=If([Department Type]='Sales',NULL(),[Department Type]) The output will be:

HTH - Regards Andy

Re: How to enable conditional value for a record to hide in a Column field

davdiste — Fri, 12 Jun 2015 09:14:56 GMT

Hi,

resolved with a trick.

In the table I've defined an expression that is always true, than in the presentation tab I've hide it.

Now Work!!!

Re: How to enable conditional value for a record to hide in a Column field

buzzy996 — Fri, 12 Jun 2015 09:16:41 GMT

PFA,

Re: How to enable conditional value for a record to hide in a Column field

davdiste — Fri, 12 Jun 2015 09:35:04 GMT

Re: How to enable conditional value for a record to hide in a Column field

buzzy996 — Fri, 12 Jun 2015 09:47:33 GMT

see in attached file.

Re: How to enable conditional value for a record to hide in a Column field

Anonymous — Fri, 12 Jun 2015 10:12:31 GMT

Andy, It is done.

Thanks for your response and time.

Re: How to enable conditional value for a record to hide in a Column field

awhitfield — Fri, 12 Jun 2015 10:42:44 GMT

Excellent!

Andy

Re: How to enable conditional value for a record to hide in a Column field

Anonymous — Fri, 12 Jun 2015 11:00:18 GMT

Andy,

For suppose, if we want to hide other field for example 'HR' also in 'Department Type' what would be the expression.

Req: "Sales" and "HR" should miss in records of column "Department Type".

"Date" "Category" "Department Type" "Employee"

1 IT Software A

2 NonIT Sales B

3 NonIT Sales C

4 IT Software D

5 IT Software E

6 IT-Related HR F

Re: How to enable conditional value for a record to hide in a Column field

awhitfield — Fri, 12 Jun 2015 11:11:05 GMT

Hi Shiva,

like this

=If([Department Type]='Sales' OR [Department Type]='HR',
NULL(),[Department Type])

Andy