Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
A Useful Link (I hope).
Hi Gysbert
Can you please send me PE Ed enabled QVW of this tutorial?
Many thanks in advance!
BR
Shoaib
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.