Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

rcorcoran
Contributor

Chart by Quarter

Hi

I have a date made for YearMonth as below but I need on to show YearQuarter any help appreciated

MonthName(Date(makedate(ReferredYYYY,ReferredMM))) as YearMonth,

Thanks

2 Replies
Digvijay_Singh
Honored Contributor III

Re: Chart by Quarter

Do you mean you need to create quarter field and use it as dimension? This is the way we create quarter from date field.

'Q' & Ceil(Month(TempDate)/3) as Quarter,

nagarjuna_kotha
Valued Contributor II

Re: Chart by Quarter

Hi

Try this:

'Q' & Ceil(Month(DateField)/3) as Quarter,

Year(DateField) as Year

Use this two expressions in backend and In chat Take two dimemtions Year and Quarter.

Regards,

Nag

Community Browser