Calendar Help

[sona_sa]

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, 

AK

[Vegar]

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)

[Brett_Bleess]

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/Dat...

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/dat...

Regards,
Brett