Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vinod2086
Contributor II

How to filter time period to( month year) and quarter year

Hi All,

i have a Time Period(YYYYMM) in my data in that i want to filter Time Period into

"Month Year" like Jan2017..etc and

"Quarter Year" like Q12017,Q22017..etc

please help on this

Thanks in advance.

3 Replies

Re: How to filter time period to( month year) and quarter year

Try with this

Load

Period,

Date(Period,'MMM-YYYY') as [Month Year]

'Q' & ceil(Month(Period)/3)&Year(Period) as [Quarter Year]

From Source;

jayshrinipurte
Contributor

Re: How to filter time period to( month year) and quarter year

Hi V Kumar...

Load *,

Month&''&year as MonthYear,

'Q' & ceil(Month(TRANDATE)/3)&year as [Quarter Year];

LOAD

year(TRANDATE) as year,

Month(TRANDATE) as MonthYear

Re: How to filter time period to( month year) and quarter year

Check the attached hope you are looking for this.

Output

op555.PNG