topic Re: Re: Restricting Dimensional Items Dsiplay in QlikView

Restricting Dimensional Items Dsiplay

Tue, 25 Nov 2014 01:42:51 GMT

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

Re: Restricting Dimensional Items Dsiplay

Tue, 25 Nov 2014 02:05:36 GMT

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

Re: Restricting Dimensional Items Dsiplay

Anonymous — Tue, 25 Nov 2014 02:15:37 GMT

Hey,

here it is .

PFA..

BR,

Chinna

Re: Restricting Dimensional Items Dsiplay

jagan — Tue, 25 Nov 2014 02:23:43 GMT

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.

Re: Restricting Dimensional Items Dsiplay

Tue, 25 Nov 2014 03:42:22 GMT

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

Re: Re: Restricting Dimensional Items Dsiplay

Anonymous — Tue, 25 Nov 2014 03:47:49 GMT

Hi,

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

PFA

BR,

Chinna