topic Re: chart and dates in QlikView

chart and dates

Thu, 25 Jun 2015 10:45:37 GMT

Hi,

I am creating a new chart, The only Dimension is a date field which I would like to display as DD-MM 25-06 (drop the year) to save some space on the screen. I have created the dimension with a formula which does the job but it seems to be slower now, maybe because it has to do a calculation on the Dimension? Is there no way to leave the Dimension column with just my date field (no formula applied) and then present it as 25-06 . I could not see the Dimensions in any formatting options, only the Expressions appear in the Numbers tab where I can apply some formatting.

Thank you!

Panos.

Re: chart and dates

PrashantSangle — Thu, 25 Jun 2015 10:51:13 GMT

Hi,

Create in script .

date(datefield,'DD-MM') as new_Date

and use this field as dimension.

Regards

Re: chart and dates

Thu, 25 Jun 2015 11:39:30 GMT

Thanks but will this work as if I have a date from 01-01-2014 and another from 01-01-2015 it will add them up as they will have the same value? Not desirable, wrong result basically.

Panos