Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
krmvacar
Creator II
Creator II

Month Format Previous

Hi All, 

I have data like in excel below.date field comes as turkish and long month name.

How can I show the previous month here?

thank  you in advance for the answer.

 

Best Regards

 

krmvacar_0-1683719825327.png

 

Labels (3)
1 Reply
Chanty4u
MVP
MVP

Not sure but try this 

SET ThousandSep='.';

 

SET DecimalSep=',';

 

SET MoneyThousandSep='.';

 

SET MoneyDecimalSep=',';

 

SET MoneyFormat='#.##0,00 ₺;-#.##0,00 ₺';

 

SET TimeFormat='hh:mm:ss';

 

SET DateFormat='DD/MM/YYYY';

 

SET TimestampFormat='DD/MM/YYYYhh:mm:ss[.fff]';

 

Expression:

=MonthName(AddMonths(Today(), -1), 'MMMM', 'tr-TR')