topic Re: Date as dimension but showing only month in chart in QlikView

Date as dimension but showing only month in chart

linusblomberg — Fri, 16 Oct 2015 11:39:23 GMT

Is it possible to have a linechart with date as a hidden dimension but displaying month as kind of a reference to what dates are displayed?

I'll try to visualize what I'm trying to accomplish

In this example I have selected Jan, Feb, Mar and Apr. The reference can be either on the first or 15 doesn't really matter.

Any help is appreciated

Thank you

sebastianlettner — Fri, 16 Oct 2015 14:02:41 GMT

HI,

if you use a master calendar add an additional field (e.g. dspMonth)

Cal:
LOAD
     Date,
     Dual(If(Day(Date) = 1, MonthName(Date), ''), Date) as dspMonth // Reference on 1st day
...

and use dspMonth as Dimension.

If you need the reference on the 15th day use

If(Day(Date) = 15, ...

If(Day(Date) = 1 or Day(Date) = 15, ...

if you want two references.

Regards

Sebastian Lettner

linusblomberg — Fri, 16 Oct 2015 14:17:19 GMT

Interesting approach. I will try it.

I tried adding an extra expression with "text on axis"

if(right(%Date,2)=15,MonthShort,null())

This works just as I want it but the text is Strike through and I can't manage to remove it?

I'll give your example a try.

Anonymous — Tue, 20 Oct 2015 16:54:16 GMT

Sebastian,

That is nice. I have done similar before in the front end, but your way in the load script is much easier.