Discussion board where members can learn more about Qlik Sense App Development and Usage.
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
The values are displayed wrong
Go to Solution.
The Dailyreport and Resource Tables are connected with POD.
i think you have to consider resource also in the link.
try the below script:
POD&'-'&Resource as KEY
(ooxml, embedded labels, table is Sheet1);
POD as Resource_POD,
POD&'-'&Name as KEY
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'
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
thank you ...
It worked well
thanks a lot
even then the values of nishant and Priyanka does not match with the given data
Y it is not matching...pls help
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