topic Re: Date filters in QlikView

Date filters

Fri, 23 Nov 2012 16:27:00 GMT

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!

SAK

Re: Date filters

swuehl — Fri, 23 Nov 2012 16:33:36 GMT

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

Re: Date filters

Gysbert_Wassenaar — Fri, 23 Nov 2012 17:12:46 GMT

A Useful Link (I hope).

Re: Date filters

Sat, 24 Nov 2012 09:16:29 GMT

Hi Gysbert

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

Many thanks in advance!

Shoaib

Re: Date filters

jagan — Sat, 24 Nov 2012 09:45:56 GMT

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.