Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

chart and dates

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.

2 Replies
PrashantSangle

Hi,

Create in script .

like

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

and use this field as dimension.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Not applicable
Author

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