Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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.

11 Replies
Not applicable
Author

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

Try this in dimension...

alexandros17
Partner - Champion III
Partner - Champion III

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

awhitfield
Partner - Champion
Partner - Champion

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

davdiste
Partner - Creator
Partner - Creator

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!!! resolved_static dimension.tif

buzzy996
Master II
Master II

PFA,

davdiste
Partner - Creator
Partner - Creator

?

buzzy996
Master II
Master II

see in attached file.

Anonymous
Not applicable
Author

Andy, It is done.

Thanks for your response and time.

awhitfield
Partner - Champion
Partner - Champion

Excellent!

Andy