Dealing with Salesforce Periods in Qlikview

SalesForce is brilliant and reporting on it in Qlikview is really easy with the Qlikview SalesForce Connector.

--However reporting on Forecasts with actual amounts turns into a bit of a nightmare, see below for how I've started puzzling this out

SQL Report Server OPS monitor

Time for something completely different, I'm of the opinion that whilst Qlikview is great for dash-boarding, sometimes having a SQL reporting server gives you functionality that can be useful.

I've created a useful dashboard that allows monitoring of the SQL reporting execution logs.


Edit: now including screenshots of what's included

Qlikview Charts with Colours

Matt over at Qlikview Addict, recently posted about how to create Gantt Charts in Qlikview.


Here's my quick post about how I customized my Gantt chart to colour my chart based off dates and adding a couple more data guidelines.  Please note that you will need to follow the original article before starting this...