How to make the dashboard to hide certain information?

[#1]

Hi,

I have problem to do the display certain information in the qlikview

How I can hide certain information in my dashboard?For example, I want the dashboard do not display any information in the EMployment Status that is stated 'Not Active'.

I want the graphs, and the other filters do not show the 'Not Active' employees.

Regards,

Kama

[#2]

HI,

When I edit the sript

I got thhis error,

[rustyfishbones]

Hi the issue here is with the ! on the SQL SELECT

It should be

SELECT
*

FROM TableName

WHERE EMployment Status <> 'Not Active';

[jagan]

Hi,

I think the issue is with Not Equal to operator, try this

TableName:

SQL SELECT

*

FROM DataSource

WHERE EMployment Status <> 'Not Active';

I think the space in column name EMployment Status is also causing the issue, try this where condition

WHERE [EMployment Status] <> 'Not Active';

WHERE [EMployment Status] != 'Not Active';

OR

TableName:

SQL SELECT

*

FROM DataSource

WHERE [EMployment Status] NOT IN ( 'Not Active');

Which database are you using?

Hope this helps you.

Regards,

Jagan.