topic Re: Calendar Help in QlikView

Calendar Help

sona_sa — Sat, 01 Jun 2019 11:18:23 GMT

Hi Team,

I have calendar. Where Date, Year, Quarter Week and Days are available, But all these are have different - different fileds / dimensions. Now I need all parameter in a single filed. Which will contain - Quarter- Year(Q1-2018, Q2-2018 etc.), Month-Year (Jan-2018, Feb-2018, Mar-2018), year etc in a single dimension.

Can any one help me on this. Below is attached QVW.

Thanks,

Re: Calendar Help

Vegar — Sat, 01 Jun 2019 13:01:07 GMT

I would recommend you to look at this page getting to know the Qlik time and date functions: https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFu...

Pay extra attention to these three functions.
MonthName()
WeekName()
QuarterName()

An often used alternative to quartername() is
year([DateValue])&'-'& 'Q' & CEIL(NUM(MONTH([DateValue]))/3)

Re: Calendar Help

Brett_Bleess — Wed, 03 Jul 2019 20:37:14 GMT

Just in case the Sense reference threw you, here are the equivalent QlikView links:

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm

Here is a link to interpretations Help, that might come in handy as well:

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/date-time-interpretation.htm

Regards,
Brett