Need to hide fields from the column

[QlikViewStartup]

Hi All, 

I get 400 users data who work in multiple departments from my data source, but I need to show only 89 who belong to my department. 

how can I do that, need your help.

Anax.

[JordyWegman]

Hi,

You can solve this in different ways:

• Script: Create a where statement

Table:
Load
   *
From [YourSource] (qvd)
Where [Department] = 'YourValue'
;

• Front-end dimension: Create an IF statement and suppress Null() values in the dimension.

IF( [Department] = 'YourValue',
      [Department],
      null()
)

• Front-end measure: Use set analysis

Sum( {$< [Department] = {'YourValue'} >} [Measure] )

Jordy

Climber