Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

Date as Dimension in a Chart

Hi ! I'm new in qlik sense. I wanna know how can I put the Date as dimension in a chart. I want the date as 'MMM-YY', but the bars in the chart doesnt agrupe (first Phott). I tried to put the dimension "Month(Fecha)&' - '&Year(Fecha)", but I cant sort it (second Photo) . Plz Help ❤️ !!

Sin título.pngSin título2.png

Labels (4)
1 Reply
Valued Contributor

Re: Date as Dimension in a Chart

The easiest solution that I know is to use a Master Calendar.  Each date is associated with fields like MonYR, FiscalYr, CalYr, etc...

You define the fields that you need in the Master Calendar and those are the Dimensions that you use.