topic Re: Calendar chart with weekend in QlikView

Calendar chart with weekend

Mon, 01 Jun 2015 06:56:28 GMT

Hi,

How to show Qlikview Master Calendar with blue text color for weekend days?

Please refer to the snapshot for expectation and attached .qvw example.

Re: Calendar chart with weekend

Tue, 02 Jun 2015 00:48:21 GMT

Any suggestion? Or it needs some Qlikview new developments?

Re: Calendar chart with weekend

Anonymous — Tue, 02 Jun 2015 01:25:01 GMT

Calendar object is not customizable, sorry.

You need either some extension object (try to look around, maybe there is what you need), or a table imitating a calendar.

Re: Calendar chart with weekend

Tue, 02 Jun 2015 01:38:56 GMT

Thank you for the confirmation.

Disappointed to hear about that. Many of us have limited coding skills. Since Qlik is good at visualization, is it possible for Qlikview to enhance this and make it customizable? Are you able to escalate this to Qlik tech team?

Re: Calendar chart with weekend

vardhancse — Tue, 02 Jun 2015 03:27:24 GMT

Yes standard objects are not possible to customize.

I think once can go though customize options if possible if not we can raise a case with qlik tech team to enhance this option in next future releases

Re: Calendar chart with weekend

Tue, 02 Jun 2015 08:43:33 GMT

For the time being sounds like extension is the way to go.

How to code an extension? A .qvw with a special extension can run without problem on others' QV?

Re: Calendar chart with weekend

Anonymous — Tue, 02 Jun 2015 12:45:34 GMT

I can't help with creating extensions.

As for using extensions - the same extension can be used in many QV files. If your want an extension to work on other users machines or on QV Server, the extension must be installed there.

Re: Calendar chart with weekend

Wed, 03 Jun 2015 01:03:25 GMT

QV server in my company is maintained by IT. It's not so straight forward to add an extension there in terms of IT procedure, if I could code one (or find one from Qlik community).

Back to the original question. Calendar is commonly used in our daily life. We get used to see a day displayed in different color to identify if it's a weekend, holiday or normal working day.

Why Qlik can't do it easily?

Re: Calendar chart with weekend

pratap6699 — Wed, 03 Jun 2015 04:56:08 GMT

mastercalender:

LOAD

date,

weekday(date) as weekday,

by using this weekday field we get the weekend dates and weekday dates also from front end

frontend::: count({<date={'Sat','Sun'}>}date) we get how many days from date field which contains satday and sunday

as well as sum({<date={'Sat','Sun'}>}sales) we get weekend sales

Re: Calendar chart with weekend

jonathandienst — Wed, 03 Jun 2015 06:13:42 GMT

Add your request to the Ideas area of the site. Click Create on the menu above and then click Idea.

(Search the Idea area first to ensure that there is not already one there - it it exists, then vote on the idea)

Re: Calendar chart with weekend

Wed, 03 Jun 2015 06:27:01 GMT

Is this the Ideas Area?

https://community.qlik.com/ideas

Got below message --

Access to this place or content is restricted. If you think this is a mistake, please contact your administrator or the person who directed you here.

Re: Calendar chart with weekend

Wed, 03 Jun 2015 06:28:56 GMT

Does it play the desired 'trick'?