topic Re: Date format in QlikView

Date format

Wed, 25 Nov 2020 16:16:04 GMT

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

sunny_talwar — Tue, 15 Nov 2016 20:45:58 GMT

Try this may be:

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

Tue, 15 Nov 2016 20:54:50 GMT

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 — Tue, 15 Nov 2016 20:56:19 GMT

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 — Tue, 15 Nov 2016 20:58:01 GMT

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

Tue, 15 Nov 2016 21:02:57 GMT

I want to show

The total no of populatikn and date format as

Above mentioned

MarcoWedel — Tue, 15 Nov 2016 22:45:29 GMT

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

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