Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
In my QVW, I have several fields for date. They are dates for different things: Assembly Date, Order Date, Delivery Date, etc.
I want to create a list box where the user can select a year or several years, and then populate a table with everything that happened in that time period. So if the user selected the year 1996, they could see everything that had been assembled, ordered, and delivered in 1996.
I do not want to just give all the date fields the same name, as I am worried that will create circular reference problems. Does anyone know of other solutions?
See
Qlikview Cookbook: Tutorial - Using Common Date Dimensions http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/
and
http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date
-Rob
How many Date fields ? If you have already combined the data into 1 table, you could build a calendar lookup like this:
OriginalFact
load
Date1,
Date2,
Date3,
*
from <source>
NewFact
load
Date1 as CommonDate,
Date1,
Date2,
Date3
resident OriginalFact;
concatenate (NewFact)
load
Date2 as CommonDate,
Date1,
Date2,
Date3
resident OriginalFact;
concatenate (NewFact)
load
Date3 as CommonDate,
Date1,
Date2,
Date3
resident OriginalFact;
drop table OriginalFact;
and then add your year , month and other calculations off the 'CommonDate' field...preferably in a calendar table.
See
Qlikview Cookbook: Tutorial - Using Common Date Dimensions http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/
and
http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date
-Rob
I have tried the tutorial and wanted to apply it in Qlik Sense, i noticed, qlik sense does not support....subroutine scripts..
i am facing multiple dates data , but my development is using qlik sense.