Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to Calculate the In-service% vs Out-of-service% of an equipment in an year, using bar chart?

Hi,

I have an employee's Work Calendar,

example

Equipment#Service Start DateService End Date
0000129/01/1530/05/15
0000124/07/1529/11/15
0000102/05/1412/10/14

Now, Want to create a bar chat(similar to below image) for In-Service% Vs Out-Of-service% across the year     Chart !.jpg

Kindly help on this

2 Replies

Re: How to Calculate the In-service% vs Out-of-service% of an equipment in an year, using bar chart?

I think you will need to create the missing data and link them per intervalmatch to a master-calendar:

Generating Missing Data In QlikView

IntervalMatch

How to use - Master-Calendar and Date-Values

- Marcus

brunobertels
Valued Contributor

Re: How to Calculate the In-service% vs Out-of-service% of an equipment in an year, using bar chart?

Hi

May be this

% Start :

count("Service Start Date") /  ( count("Service Start Date") + count("Service End Date") )

% End

count("Service End Date") /  ( count("Service Start Date") + count("Service End Date") )

in your graph :

Dimension YEARS

MESURES :

% Start

% End

select stacked option in graph panel

Hope it helps

Community Browser