Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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?
Sorry, but I still have difficulty in understanding
for 30/12/2019 is not a holiday day but have 3 on 0Day ?
See dashboard attached
Lorenzo