Creating a progress/aging table

[ciphergod]

Hi all,

Need some help or perhaps just some directions on how to create the table i want. I am currently tracking the response time of each team/dept to incidents/tickets in excel. I have attached how a sample table looks like.

It consist of 2 tables, one for calendar and one for working days. I usually will pull the raw data from our internal systems which comes out as excel, and copy paste into an already formulated excel file.

I want to now just place this raw file into a folder which I can just refresh within Qliksense and give me the latest data based on the raw data.

Here's what i've done so far. I have loaded two files, the one with raw data and one with the list of public holidays. I have concatenated the public holidays, and created Master Dimension for CalendarDays and WorkDays, which i've check are giving accurate output when placed in a table/chart. 

My issues starts here, how to get create an app that gives a table that looks like the one i have attached? I have totally no directions on how to start here. Is is possible to do this with scripting? If not possible, how do i go about doing it?

Would appreciate some guidance or directions.

Thanks in advance!

[lorenzoconforti]

Maybe you can share the complete excel file so that we can have a look at the formulas you are using? Rather than just the resulting tables

[ciphergod]

hello all,

my apologies, perhaps it was confusing, i spent some time to create a separate excel that shows what im looking for with the formula. hope this is cleared, ive attached the file.

basically i have the Data(those in the excel are those that needs to be tracked in some capacity), i also have holidays dates.

from there i want to form a table that looks like that in the Table sheet. For excel i can formulate each cell as you can see, but how do i make a table that looks like this in qliksense?

[Taoufiq_Zarra]

Sorry, but I still have difficulty in understanding

for 30/12/2019 is not a holiday day but have 3 on 0Day ?

[lorenzoconforti · Accepted solution]

See dashboard attached

Lorenzo

[ciphergod]

Hi Lorenzo, Thanks for your input, i actually managed to get the output i want using pivot table after a few days of playing around with this. But i love the idea of how you did this too, this is also what i wanted. Thank alot.