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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date format

Hi my date format is as below

date

2016 apr

2016 mar

2016 feb

i want to convert thisinto to the below format

Date

apr-2016

mar-2016

feb-2016

Note  iwant this to be done in a text object

6 Replies
sunny_talwar

Try this may be:

LOAD Date(Date#(date, 'YYYY MMM'), 'MMM-YYYY') as Date

Not applicable
Author

Hi sunny i want this in a text object

I have loaded the script and got the values

How can i show date as mentioned above in text object

its_anandrjs
Champion III
Champion III

In a script level try this way by making new field

Load

Lower(Date(date,'MMM-YYYY')) as NewDatefield

From Source;

And in the front end try to create the text object as

=Concat(DISTINCT NewDatefield,' ')

Regards

Anand

its_anandrjs
Champion III
Champion III

In text object write

=Concat(DISTINCT NewDatefield,' ')


Note:- But why not you use list box for this what is the purpose and reason.


Regards

Anand

Not applicable
Author

I want to show

The total no of populatikn and date format as

Above mentioned

MarcoWedel

=Right(date,3)&'-'&Left(date,4)

(only returns result for one possible/selected value of date field)