Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

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

View solution in original post

3 Replies
prabhuappu
Creator II
Creator II

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
Specialist
Specialist

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

View solution in original post

markodonovan
Specialist
Specialist

Hi Swanilda,


Please find attached a qvf with a calendar table example.


Thanks


Mark !


www.youtube.com/practicalqlik