Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Dhivya_123
Contributor

Bar chart report

Hi,

I want to create a leakage report using bar chart.

I want one bar showing actual allocated hours,

2nd bar showing hours worked and 3rd bar showing leakage(=actual -allocated)

I want it daily as well as week wise.

if I use sum(hours worked) expression for daily it is totalling the hours for the particular resource .

Please help me with this

please find the sample attachment

Capture.PNG

The values are displayed wrong

1 Solution

Accepted Solutions
mdmukramali
Valued Contributor II

Re: Bar chart report

Hi Dhivya,

The Dailyreport and Resource Tables are connected with POD.

i think you have to consider resource also in the link.

try the below script:

Directory;

LOAD POD,

    [User Story],

    [Description/Ticket],

    Status,

    Resource,

    Technology,

    Date,

    Hours,

    POD&'-'&Resource as KEY

FROM

dailyreport.xlsx

(ooxml, embedded labels, table is Sheet1);

Directory;

LOAD Role,

    Name,

    POD as Resource_POD,

    [Hours Allocated],

    [Daily Hours],

    POD&'-'&Name as KEY

FROM

resource.xlsx

(ooxml, embedded labels, table is Sheet1);

10 Replies
mdmukramali
Valued Contributor II

Re: Bar chart report

Hi ,

PFA.

Dhivya_123
Contributor

Re: Bar chart report

Thank you..

But check with the name 'Soumya'. the worked hour is always '0'.

But it is showing the value wrong

and for 'Nishant' the records are present but it is showing ' no data to display'

mdmukramali
Valued Contributor II

Re: Bar chart report

Hi Dhivya,

The Dailyreport and Resource Tables are connected with POD.

i think you have to consider resource also in the link.

try the below script:

Directory;

LOAD POD,

    [User Story],

    [Description/Ticket],

    Status,

    Resource,

    Technology,

    Date,

    Hours,

    POD&'-'&Resource as KEY

FROM

dailyreport.xlsx

(ooxml, embedded labels, table is Sheet1);

Directory;

LOAD Role,

    Name,

    POD as Resource_POD,

    [Hours Allocated],

    [Daily Hours],

    POD&'-'&Name as KEY

FROM

resource.xlsx

(ooxml, embedded labels, table is Sheet1);

Dhivya_123
Contributor

Re: Bar chart report

In weekly chart, when I user Weekend(date) it shows me Sunday date.

but I want to display Friday date.

please help with this also

Dhivya_123
Contributor

Re: Bar chart report

thank you ...

It worked wellSmiley Happy

mdmukramali
Valued Contributor II

Re: Bar chart report

Hi ,

Try this

=Date(Weekend(Date)-2,'DD/MM/YYYY')

Dhivya_123
Contributor

Re: Bar chart report

thanks a lotSmiley Happy

Dhivya_123
Contributor

Re: Bar chart report

even then the values of nishant and Priyanka does not match with the given dataSmiley Sad

Y it is not matching...pls help

mdmukramali
Valued Contributor II

Re: Bar chart report

Hi,

in Both the Excel files POD value should be same ( Case Sensitive)

for Nishant Case in Resources Excel file :  in Plan 'p' is same letter

POD : Protection plan


in Daily Report Excel file :  in Plan 'P' is Capital letter


POD: Protection Plan



Community Browser