topic Chart by Quarter in QlikView

Chart by Quarter

rcorcoran — Tue, 22 Sep 2015 08:51:44 GMT

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

Digvijay_Singh — Wed, 23 Sep 2015 05:15:10 GMT

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 — Wed, 23 Sep 2015 05:40:03 GMT

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