Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Swanilda,
It is worth looking into calendar tables.
Here is a link to a document on calendar tables:
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
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
Hi Swanilda,
It is worth looking into calendar tables.
Here is a link to a document on calendar tables:
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
Hi Swanilda,
Please find attached a qvf with a calendar table example.
Thanks
Mark !
www.youtube.com/practicalqlik