topic Re: Multiple Calendars In One Qlik Sense App in App Development

Multiple Calendars In One Qlik Sense App

ShellyG — Sat, 16 Nov 2024 17:42:19 GMT

Dear all,

I need some help with an app that I am currently developing. I will begin with explaining that it is a ticketing application and it shows statistics related to the tickets that our support teams receive.

I have different type of tickets, such as - open, closed, work in progress, backlog, etc...

Currently my data model consists of:
1. Main Table, which contains all the data I need of the ticketing calculations

2. Table with data for the employees, which is connected to the main table by a key

3. Two calendars connected to the main table using the same key (the key is connected to the created time of the tickets in the main table); One of the calendars consists of calendar fields and the other one of fiscal fields. I did that change as I needed to have a switch between fiscal and calendar dates.

The problem that I have is related to the closed tickets. I need them to be taking into account the closed time, not the created time, as it is for the other types of tickets, because of the way I have connected the calendars to the main table. I have only one key in field in the calendar and I have already used it for the created time...

Can you help me with ideas on how to achieve this?

Re: Multiple Calendars In One Qlik Sense App

ShellyG — Thu, 17 Dec 2020 13:48:43 GMT

Hey guys,

I found a solution to this one myself, maybe it will be useful to someone in the future, so:

1. I added the third calendar with the fields that I needed and then I qualified them, so that I can distinguish them from the fields in the main calendar.
2. I used the same key that I used for the first 2 calendars that I have, with the only difference that I qualified it as well and I have associated it with the completed time in the main table, instead of the created time

Afterwards I only needed to pay attention where I need the completed time and where I need the created, so that I know which fields to use. 🙂

Re: Multiple Calendars In One Qlik Sense App

BarryG — Wed, 22 Jun 2022 04:31:07 GMT

could you please share the solution if you don't mind? My scenario is this:

https://community.qlik.com/t5/New-to-Qlik-Sense/Need-to-create-a-graph-showing-Started-Closed-and-backlog/td-p/1944481