Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Please post a small qlikview document that demonstrates the problem.
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.
Create a new Dimension based on your Date field as
DATE(DATEFIELD,'MMM-YYYY')