topic Formats in QlikView

Formats

Anonymous — Tue, 04 Jan 2011 01:18:37 GMT

question 1:

I have a sql statement in oracle which trucates the month in the format 'dd-mm-yyyy hr:mm:ss'. it gives the first day in a month as month , when i select that column to display as month and change the number format to date i get just date displayed , instead how do i get name of the month for eg : 01-11-2010 as Nov.

question 2 :

I have a dimension which project names which are both characters and numbers , when i select project as a dimension in a chart i get only project names with characters not numbers , is there a setting in qlikview to changes to accept both numbers and characters.

Please let me know

Thanks

Formats

Tue, 04 Jan 2011 01:39:37 GMT

you can use:

Timestamp(Now(),'MMM-DD-YYYY hh:mm:ss') *with Time

Date(Now(),'MMM-DD-YYYY') *Date Only

**replace Now() with the specific field

Formats

Anonymous — Tue, 04 Jan 2011 01:41:30 GMT

Hi,

For Question 1, try looking at the Month() function:

month ( date )

Month. Returns a text string representing the month when the fraction of expr is interpreted as a date, but can be formatted as a number.

Example:

month( '1971-10-30' ) returns Oct.

If the date format used does not correspond to the one set in your operating system, QlikView will not be able to make a correct interpretation. See above under day.

Regarding the 2nd question, I'm not quite sure what you mean. Do you have an example to attach?

topic Formats in QlikView

Formats

Formats

Formats

month( date )

Example:

month ( date )