topic Re: Label Name with Rolling. in QlikView

Label Name with Rolling.

Anonymous — Thu, 01 Sep 2016 15:06:37 GMT

Hi Experts,

We want to display Month-Year (ex: Jan-16) in table when selections are made on the filters like 'Last 3 months', 'Quarter', 'Rolling Year'.

When we select 'LAST 3 MONTHS' button it should display like JAN-16,DEC-15,NOV-15. Similar to other filters also. But we are not getting the required format. Please find the attached documents.

Re: Label Name with Rolling.

Gysbert_Wassenaar — Fri, 02 Sep 2016 09:04:24 GMT

Please post a small qlikview document that demonstrates the problem.

Re: Label Name with Rolling.

rajuamet — Fri, 02 Sep 2016 09:26:02 GMT

Hi Sravan,

U have to use "Month-Year" field as Dimension. From your output I can understand that you are using "Month" field as Dimension.

Re: Label Name with Rolling.

vinieme12 — Fri, 02 Sep 2016 09:48:55 GMT

Create a new Dimension based on your Date field as

DATE(DATEFIELD,'MMM-YYYY')

Re: Label Name with Rolling.

agomes1971 — Fri, 02 Sep 2016 10:03:00 GMT

Hi,

please see this

Calculating rolling n-period totals, averages or other aggregations

HTH

André Gomes