topic Re: Strange dimension formatting in App Development

Strange dimension formatting

salezian — Tue, 20 Jun 2017 07:30:08 GMT

Dear Qlik Community,

I'm playing with Qlik Sense Cloud. I found something strange: I'm using month-year dimension formatted as MMM-YYYY. In the straight table everything works fine - format of the date is preserved. But when I create line chart format is lost and it's something like this 2017-03-02 00:00. Please take a look at the following picture:

Is there any way to fix it ?

Re: Strange dimension formatting

niclaz79 — Tue, 20 Jun 2017 07:41:22 GMT

Hi Marcin,

Have you tried putting a floor(month-year) as month-year in the script?

You should also be able to put a date(month-year,'MMM-YYYY') as the dimension.

Re: Strange dimension formatting

salezian — Tue, 20 Jun 2017 08:07:16 GMT

I've tried. Simply it doesn't work.