Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Date filters

Hi all,

I am new to qlikview.

Please advise how to make filters like year, quarter, month, dates as seen in many apps for example Executive Dashboard in gettin started section of Qlikview.

Please give some useful links

Thanks in advance!

BR

SAK

4 Replies
swuehl
Not applicable

Re: Date filters

Create fields for year, quarter, month in your data model (e.g. using a master calendar), then create list box sheet objetcs.

I would suggest that you download and go through the QV tuturial, that will guide you through these steps, AFAIR.

Hope this helps,

Stefan

Gysbert_Wassenaar
Not applicable

Re: Date filters

A Useful Link (I hope).


talk is cheap, supply exceeds demand
Not applicable

Re: Date filters

Hi Gysbert

Can you please send me PE Ed enabled QVW of this tutorial?

Many thanks in advance!

BR

Shoaib

jagan
Not applicable

Re: Date filters

Hi,

Try script below

TableName:

LOAD

     DateField,

     Year(DateField) AS Year,

     Month(DateField) AS Month,

     Week(DateField) AS Week,

     'Q1' & Ceil(Month(DateField)/3) AS Quarter

FROM DataSource;

Regards,

Jagan.