Restricting Dimensional Items Dsiplay

[#1]

Hi

   Appreciate very much if you could help me as I am new for QV.

In the attached Dashboard "Workers Incident DB",

1. Under the Caption "Gender", The "Undefined" should not be displayed (only female and male to be displayed). Appreciate if you could let me know how I could do that at the Report level and ETL level.

2. Under "Incident By Category", please let me know how I could display only "LTI" & "MTI" only at Report level.

Thanks

Flavian

[#2]

Hi,

1. There are nulls in your gender field, thus undefiined is coming.

2. use count({<[Incident Category]={'LTI','MTI'}>}Surname) in epression of Incident in category.

Regards,

Navdeep

[Anonymous]

Hey,

here it is .

PFA..

BR,

Chinna

[jagan · Accepted solution]

Hi,

In script filter the Undefined records by using where condition in script like below

LOAD Service,

     [Type Of Employment],

     Age,

     Gender,

     SAC,

     [Incident Type],

     [First Name],

     Surname,

     [Type of Worker],

     [Type of Incident],

     Harm,

     [Injured Workers Manager],

     [Incident Date],

     [Incident Category]

FROM

(biff, embedded labels, table is Sheet1$)

WHERE Gender <> 'Undefined';

For displaying 'LTI' and 'MTI' categories use below expression

=Count({<[Incident Category]={'LTI','MTI'}>} Surname)

Hope this helps you.

Regards,

Jagan.

[#5]

Hi

Thanks very much.

Please let me know for example, for the "Harmful Injuries" chart, How to put a Benchmark/Traget line.

For eample, if "No. of Harmful Incidents" Target is = 60

Thanks

Flavian

[Anonymous]

Hi,

Add a referece line either static or based on your crieteria.

PFA

BR,

Chinna