Add Years to Sample App in Qlik Sense Cloud

[#1]

Using Qlik Sense Cloud, I’m evaluating the feasability of using this software to dig into my personal stock trading transactions.  I have followed the first two tuition apps (Beginner’s and Building an app). Then, in attempting to build my own app I have encountered the problem of building a filter for the dates (“Period” in the two sample apps mentioned), with the intention of adding it into my customized master dimensions.

I ended up in confusion and then attempted to copy the date filter set up from the sample app, with again much confusion, being unable to find any guidance in the help file. I then discovered that I could duplicate an entire sheet, which I did, with the intention of adopting one of the sample apps as a guide, deleting unnecessary facets and retaining the ones useful, such as the date filter and its attribution to the  master dimensions.

This marked a progress and seemed to allow me to proceed to the desired customization; but unfortunately the sample that I start from includes dates which are “out of date”; in particular the years 2015 and 2016 are not included.

As I find no way to add these years in the list and nowhere in the help or on the site I was able to find any discussion on this issue, that should not be unusual for newcomers like me. May you kindly address me to understandable instructions or provide directly the necessary guidance.

Thank you kindly

AT

Rome

  Oct.21, 2016 

[MK9885]

Maybe create a Master Calendar?

To that you can add years

From till date. Or From to particular year. Check for Master Calendar related posts in community. You'll find an ready script for Calendar. You just need to enter your own years to match with the data.

Also you need to link that Calendar table to your fact. Maybe if you have DateID as key in your fact?

An expert on dates/months/years can help you more.

Thanks.

[#3]

Thank you kindly for your assistance on my issue. Through an occasional visit to Youtube I have found a video about “Understanding master calendar” which does not seem to be sufficiently emphasized in the help section of Qlik. It helped me to rationalize the matter.

Thank you again

Alfonso  

Da: arvind654

Inviato: venerdì 21 ottobre 2016 17:37

A: Alfonso Trivoli <alfonso.trivoli@studiotrivoli.it>

Oggetto: Re: - Add Years to Sample App in Qlik Sense Cloud

[lakshmikandh]

create calender using this script this will help,

tabCalendar:

LOAD *,

    Day(Date) as Day,

    WeekDay(Date) as WeekDay,   

    Week(Date) as Week,

    WeekName(Date) as WeekName,

    Month(Date) as Month,

    MonthName(Date) as MonthName,

    QuarterName(Date) as QuarterName,

    Year(Date) as Year,

    WeekYear(Date) as WeekYear;

LOAD Date(Date#('01/01/2005', 'MM/DD/YYYY')+IterNo()-1) as Date

AutoGenerate 1

While Date#('01/01/2005', 'MM/DD/YYYY')+IterNo()-1 <= Today();

[#5]

Thank you kindly for your help

Alfonso

Da: Lakshmikandh Karthikeyan

Inviato: lunedì 24 ottobre 2016 09:39

A: Alfonso Trivoli <alfonso.trivoli@studiotrivoli.it>

Oggetto: Re: - Add Years to Sample App in Qlik Sense Cloud