Create Date Ranges using Qlik Sense

[#1]

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

[prabhuappu]

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 · Accepted solution]

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

[markodonovan]

Hi Swanilda,

Please find attached a qvf with a calendar table example.

Thanks

Mark !

www.youtube.com/practicalqlik