Code Monkey home page Code Monkey logo

sense-calendar-heatmap's Introduction

Calendar Heatmap

Qlik Sense Visualization Extension with a diverging color scale. The values are displayed as colored cells per day. Days are arranged into columns by week, then grouped by month and years.

Screenshot

Installation

  1. Download the latest version
  2. Qlik Sense Desktop
    • To install, copy all files in the .zip file to folder "C:\Users%USERNAME%\Documents\Qlik\Sense\Extensions\swr-CalendarHeatmap"
  3. Qlik Sense Server

There is also a demo available, if you want to see a working example.

Configuration

After installing the extension the following properties can be set:

Data Definition

Property Description Values
Unique day Field containing the unique day. Note that you just have to type in the field name without equal sign (=). Example:
Dim1 or [Dimension with Space]
Value Expression which needs to result in a valid numeric number (positive or negative).

Note: Define the expression without a leading equal sign (=).		 Example:
[round(Sum([TableX.FieldWhatever]),0.001)
Tooltip: You can (optionally) define the tool tip display when hovering a day.

Appearance / Debug Mode

If you want to see which data are passed to the Calendar Heatmap visualization, you can temporarily enable the Debug Mode. By doing so only the data returned from the QIX engine will be displayed in a table.

The Debug Mode can only be activated and you'll only see the resulting table in Edit Mode of Qlik Sense.

Limitations

  • For performance reasons only 1500 rows will be returned (so 1500 days).

Ideas for Improvement

I'd like to look into the following areas to improve this Visualization Extension for Qlik Sense:

  • Skip rendering of years not included in the data
  • Performance improvements
  • Better, configurable label
  • Offer also a week view and maybe other views
  • Support selections (both single days, weeks and years)

Contributing

Contributing to this project is welcome. The process to do so is outlined below:

  1. Create a fork of the project
  2. Work on whatever bug or feature you wish
  3. Create a pull request (PR)

I cannot guarantee that I will merge all PRs but I will evaluate them all.

Author

Stefan Walther

Change Log

See CHANGELOG.md

License & Copyright

The software is made available "AS IS" without any warranty of any kind under the MIT License (MIT).

See Additional license information for this solution.

sense-calendar-heatmap's People

Contributors

qliktap avatar

Stargazers

avatar avatar avatar avatar avatar avatar avatar avatar avatar avatar

Watchers

avatar avatar avatar avatar avatar avatar avatar

Forkers

qliktap planningguy nagyistoce alner mseeck jusolu

sense-calendar-heatmap's Issues

Calendar Heatmap getting blank

hello i am facing the problem with calendar heatmap. My Date field is unique and in expression i am using
sum(Premium) it showing blank.....
heatmap

Failed to import zip in QS version 2.0, server

Hi there Stefan! We are trying to use your lovely extension, but it is not allowing us to import. We get a failed error. Is this compatible with QS server version 2.0 and up?

Thanks!

Action required: Greenkeeper could not be activated 🚨

🚨 You need to enable Continuous Integration on all branches of this repository. 🚨

To enable Greenkeeper, you need to make sure that a commit status is reported on all branches. This is required by Greenkeeper because we are using your CI build statuses to figure out when to notify you about breaking changes.

Since we did not receive a CI status on the greenkeeper/initial branch, we assume that you still need to configure it.

If you have already set up a CI for this repository, you might need to check your configuration. Make sure it will run on all new branches. If you don’t want it to run on every branch, you can whitelist branches starting with greenkeeper/.

We recommend using Travis CI, but Greenkeeper will work with every other CI service as well.

Once you have installed CI on this repository, you’ll need to re-trigger Greenkeeper’s initial Pull Request. To do this, please delete the greenkeeper/initial branch in this repository, and then remove and re-add this repository to the Greenkeeper integration’s white list on Github. You'll find this list on your repo or organization’s settings page, under Installed GitHub Apps.

Action required: Greenkeeper could not be activated 🚨

🚨 You need to enable Continuous Integration on all branches of this repository. 🚨

To enable Greenkeeper, you need to make sure that a commit status is reported on all branches. This is required by Greenkeeper because we are using your CI build statuses to figure out when to notify you about breaking changes.

Since we did not receive a CI status on the greenkeeper/initial branch, we assume that you still need to configure it.

If you have already set up a CI for this repository, you might need to check your configuration. Make sure it will run on all new branches. If you don’t want it to run on every branch, you can whitelist branches starting with greenkeeper/.

We recommend using Travis CI, but Greenkeeper will work with every other CI service as well.

Once you have installed CI on this repository, you’ll need to re-trigger Greenkeeper’s initial Pull Request. To do this, please delete the greenkeeper/initial branch in this repository, and then remove and re-add this repository to the Greenkeeper integration’s white list on Github. You'll find this list on your repo or organization’s settings page, under Installed GitHub Apps.

Action required: Greenkeeper could not be activated 🚨

🚨 You need to enable Continuous Integration on all branches of this repository. 🚨

To enable Greenkeeper, you need to make sure that a commit status is reported on all branches. This is required by Greenkeeper because we are using your CI build statuses to figure out when to notify you about breaking changes.

Since we did not receive a CI status on the greenkeeper/initial branch, we assume that you still need to configure it.

If you have already set up a CI for this repository, you might need to check your configuration. Make sure it will run on all new branches. If you don’t want it to run on every branch, you can whitelist branches starting with greenkeeper/.

We recommend using Travis CI, but Greenkeeper will work with every other CI service as well.

Once you have installed CI on this repository, you’ll need to re-trigger Greenkeeper’s initial Pull Request. To do this, please delete the greenkeeper/initial branch in this repository, and then remove and re-add this repository to the Greenkeeper integration’s white list on Github. You'll find this list on your repo or organization’s settings page, under Installed GitHub Apps.

Tooltip is display behind parent

screen shot 2015-02-27 at 10 22 32

I've reposition the tooltip and gave it a new width, but even with a z-index i haven't yet manage to sort this one. Needs a bit more attention so i will get back to it.
The new width is 100px
and on the mouseover subtracting 30 and adding 15 for X and Y:

divTooltip.html( 'Date: ' + d.Date + '
' + (!_.isEmpty( data[d.Date] ) ? data[d.Date].ToolTip : '') )
.style( 'left', (d3.event.pageX - leftOffset - 30) + 'px' )
.style( 'top', (d3.event.pageY - divTooltip.attr( 'height' ) - topOffset + 15) + 'px' );

White Calendar

Hi

I entered Sum([TotalNoOfEvents]) in the Value expression field and in debug I can see values but when switching back to normal mode the calendar is all white.

image

image

May I know what is wrong with this?

Thank you!

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.