Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Classic Search
Unified Search allows you to search for content across the Qlik ecosystem. You have the option to revert to classic community search at any time.
Woohoo! Qlik Community has won “Best in Class Community” in the 2024
Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
- Qlik Community
- :
- Search
Search
Search the Community
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
1,000 results
Sorted by:
2018-02-19
09:19 AM
Bonjour, Je dois créer un canonical calendar pour me permettre de comparer des données avec des périmètres de dates différentes. Dans mon cas, je cherche à avoir l'ensemble des missions r...
Labels
- Subscribe by Topic:
-
Démarrer avec QlikView
2023-05-11
12:45 PM
Hello all. I'm pretty sure I'm implementing my date bridge incorrectly.
I studied again this post by HIC CanonicalDate .
I have two tables
Applications_Fact:
Load A...
Labels
- Subscribe by Topic:
-
General Question
2016-07-28
05:01 PM
2 Likes
Hello, I've seen Canonical Date Henric Cronström and Linking to two or more dates from Rob Wunderlich. But I still confused. This is the script for Canonical calendar: D...
2017-08-28
10:44 AM
I'm using the Canonical Calendar posted by Henric Cronstrom. (or let's say trying to use/implement) But i'm facing some challenges. I'm loading my sales data from a qvd. and I h...
2015-09-24
07:15 AM
Hi all, hic I have created a canonical date using below script. invitation_id2Date: Mapping Load invitation_id, Date Resident INVITATION ; i...
canonical.png (37 KB)
- Tags:
- canonical_date
2018-03-15
07:47 AM
Bonjour à tous, Je dois créer un canonical calendar pour me permettre des données selon des périmètres de dates différentes. J'ai déjà traité ce point avec deux dates en créant un calendrier p...
Labels
- Subscribe by Topic:
-
Démarrer avec QlikView
2017-06-08
04:57 PM
Is it possible to create canonical date when all your information is located in 1 table? I'm trying to create Line charts with 6 different values. I have created Master Calendar which is not so h...
Show results in replies (6)
-
The primary dimension should be your canonical date field, CanonicalDate
-
I hope I understand your request correctly, but I would say, sure, creating a canonical date b...
-
You don't need the master calendar to be able to use the canonical date as dimension. That's o...
-
...ave to have unique column for canonical date to work, even though data is from 1 table?
-
...elow columns. I want create line chart using canonical date, I have been unsuccessful so far. &n...
-
...able MEDDS. Just do DateBridge: LOAD [I_MASTER_ID], [D_CREATE_DATE] as CanonicalDate, 'CreateTest' a...
2016-11-24
01:32 PM
...hart to sums, counts, against eachother across the same time frame. I've been reading this post: Canonical Date about canonical dates, and believe this is a great method to accomplish this......
- Tags:
- canonical date
- data model
- datamodel
- developer
- dynamic data model
- master calendar
- new to qlikview
- new_to_qlikview
Show results in replies (3)
-
...bsp; ... then use this key in your canonical date table (yes, it would look like this table, o...
-
...asterCalendar and canonical date) I have the same question as Duke and try to use your solution to r...
-
...hen the generic "date" field would be the link between my "bridge table" and the "Canonical Date" C...
2019-01-04
02:23 PM
...'ve read this post https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578 and I think I am close, but not sure where I am going wrong This is what I came up with script wise and I t...
.png "Former Employee"){kind=icon}
2014-02-17
03:28 AM
219 Likes
...rdered amount and shipped amount in the same graph using a common time axis. For this you need a date that can represent all three dates – you need a Canonical Date. This is how you create it:
F...
Show results in comments (9)
-
Please have a look at my issue regarding canonical date here issue with canonical date i...
-
...hink that it is a mistake to deliver an app with canonical date only. It is an over-simplification of t...
-
...ere: Date interval - Qlik Community - 2104531 A canonical calendar could become useful if there a...
-
Hi Casey Sometimes a canonical date is not possible. So It may not be possible to have a canonical...
-
Hi hic Can you also please check for this... issue is about Canonical Date Re: Master C...
-
Anyone know why it is called a "Canonical Date" ?
-
Hi Henric Cronström, I have one doubt. Master calendar is must to create a canonical d...
-
...umber & order line number (or part number maybe) You usually have to link the Canonical to t...
-
Thanks for the post. I will use the Canonical Date solution in my dashboard.