Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Create Date Ranges using Qlik Sense

Is it possible to create a list with different date ranges to filter out a trend line or bar graph?\

Right now I have a trend line with # sales by date (yyyy-mm-dd) but I also want a filter on the side that would show to the end user

Q1, Q2, Q3, and Q4 as a pick list. It is my understanding that I would need to define the date ranges behind Q1, Q2 etc.

Can I do that in the "Edit Expressions" window?

My apologies if this is something easy to do but I am brand new to the product.

Thanks

Swanilda

1 Solution

Accepted Solutions
markodonovan
Valued Contributor

Re: Create Date Ranges using Qlik Sense

Hi Swanilda,

It is worth looking into calendar tables.

Here is a link to a document on calendar tables:

How to create a Calendar

When you have been using the product for a while it is worth looking at the QDF (QlikView Deployment Framework) which includes a function you can call to setup a calendar very easily.

Hope this helps.

Thanks

Mark

www.techstuffybooks.com

3 Replies
prabhuappu
Contributor II

Re: Create Date Ranges using Qlik Sense

Hi Swanilda,

Add Expression instead of a field while creating library dimension and use it as a Filter.

= 'Q'&CEIL(Month(OrderDate)/3)

Regards,

Prabhu Appu

markodonovan
Valued Contributor

Re: Create Date Ranges using Qlik Sense

Hi Swanilda,

It is worth looking into calendar tables.

Here is a link to a document on calendar tables:

How to create a Calendar

When you have been using the product for a while it is worth looking at the QDF (QlikView Deployment Framework) which includes a function you can call to setup a calendar very easily.

Hope this helps.

Thanks

Mark

www.techstuffybooks.com

Highlighted
markodonovan
Valued Contributor

Re: Create Date Ranges using Qlik Sense

Hi Swanilda,


Please find attached a qvf with a calendar table example.


Thanks


Mark !


www.youtube.com/practicalqlik