Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
JustTryingToLearn
Contributor II
Contributor II

Rolling Calendar Month Expression

Hi,

I would like to make a rolling bar chart that has 12 months as the bottom axis. I plan to use 3 letter month names. I would like to do this using a chart expression of some kind. Is there any way to set up the sort so that this is possible?

 

Thank you!

Labels (4)
3 Replies
Anil_Babu_Samineni

Yes, You can created MonthNum from Month field and use MonthNul as sort expression with ascending. So that, It will fix the result

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
manoranjan_d
Specialist
Specialist

 I plan to use 3 letter month names. I would like to do this using a chart expression of some kind.

>>you can use monthname function to get the three letter

monthname(your month field)

Is there any way to set up the sort so that this is possible?

>>In sorting you can try min({1}monthname(your month field))

manoranjan_d
Specialist
Specialist

Tried with sample data below is the script 

LOAD Date,
Sales,
date(MonthName(Date),'MMM') as monthname
FROM
[C:\Users\NM\Desktop\Scenarios\17 feb21\New Microsoft Excel Worksheet.xlsx]
(ooxml, embedded labels, table is Sheet2);

dim monthname

exp RangeSum(Above(Sales,0,12))

sort min({1}monthname)

manoranjan_d_1-1613509831052.png