Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Label Name with Rolling.

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.

4 Replies
Gysbert_Wassenaar

Please post a small qlikview document that demonstrates the problem.


talk is cheap, supply exceeds demand
raju_insights
Partner - Creator III
Partner - Creator III

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.

vinieme12
Champion III
Champion III

Create a new Dimension based on your Date field as

DATE(DATEFIELD,'MMM-YYYY')

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
agomes1971
Specialist II
Specialist II