Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Date format

I want to put the date format like '30-AUG-11'. I can get to '30-Aug-11', but i need the month to be written in capital letters. Thanks

1 Solution

Accepted Solutions
MVP
MVP

Date format

Sorry I don't understand..

You are not using a script? I think QV will not load anything without a script.

Maybe you used the assistant from the start page to open the excel file? This will also create a script, go to file-->edit script or use CTRL-E

You should see some line with

LOAD

...

from ...

There should be a field name indicating your date column in excel, either named or something like @1.

use the upper function on that fieldname and rename the field with as (as given by Sunil).

Or use upper(yourfield) in any expression (list box), text field etc.

Or do you want something totally different from that?

6 Replies
MVP
MVP

Date format

try upper() function, like in

=upper(Date(today(),'DD-MMM-YYYY'))

Regards,

Stefan

chauhans85
Esteemed Contributor

Date format

i believe only upper can be used

upper(datefieldname)

Not applicable

Date format

The problem is i get the date from an excel file like '20-AUG-11'. If I go to file settings, numbers and date how do i tell it to put the letters as capital letters?

chauhans85
Esteemed Contributor

Date format

while fetching in script

upper(datefieldname) as  datefieldname

Not applicable

Date format

I don#t have a common script. The only thing i do is to hold data from excels, so the date i get is in a colum of the file.

MVP
MVP

Date format

Sorry I don't understand..

You are not using a script? I think QV will not load anything without a script.

Maybe you used the assistant from the start page to open the excel file? This will also create a script, go to file-->edit script or use CTRL-E

You should see some line with

LOAD

...

from ...

There should be a field name indicating your date column in excel, either named or something like @1.

use the upper function on that fieldname and rename the field with as (as given by Sunil).

Or use upper(yourfield) in any expression (list box), text field etc.

Or do you want something totally different from that?

Community Browser