Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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')