Today I have something completely different for you. It is only tangentially related to QlikView and lacks any practical application for QlikView professionals, but I know it will make you smile when you see it.
A few years ago I was the technical lead on a project that required the development of multiple Excel dashboards. I designed and developed (together with Nico Wuite, who did a lot of the coding) an Excel plug-in that could be used to generate stand-alone, fully interactive Excel dashboards. I recently rediscovered the plugin after cleaning up my archive of Excel and VBA reference files and thought it would be fun to generate a demo dashboard.
Have a look at the embedded video below (preferably in full screen HD) and see if it reminds you of a certain BI tool ๐ Also, keep in mind that this was built before PowerPivot was released, so it is a little dated by now.
13 Comments
can u share workbook for ur video?
Great to see that there is so much interest in my dashboard. Unfortunately, I will not be able to share the workbook. A lot of time and effort went into it and, although there’s only a slight chance that I’ll actually persue it, I want to keep my options open to release it as a commercial product in the future.
I will however gladly answer any questions about how the workbook works and how certain functionality was achieved. I have no problem sharing some example code. If you have any questions then please put them in the comments section.
I too would be interested for source workbook of this video. Please provide it if possible.
That is a fantastic dashboard. Echo the requests above.
Haha!
Amazing!
Qlikview is an excel copycat! ๐
Would be fun to play with it if you want to share.
Excellent piece of work.
Lovely, kindly share with me the work book. Mail to [email protected]
Barry, this is the best ever dashboard i have ever came across, am willing to pay you if you can train me on how to creat a similar one.
This is fantastic Barry, the ideal solution for small business who may not want to spend th 20 or 30 K for QLIKVIEW basic licenses.
Perfect to utilise data from their existing system and EXCEL is the most common spreadsheet in the world ! Brilliant.
Good video.. great ideea!!!
I’ve worked in QlikView and I’m currently trying to develop a similar dashboard for any type of data. I’ts really hard work… the codes in vba especially.
Great work!
Cheers!
And I was under impression I’m good in excel… This is amazing!
Good video,can you forward me workbook for practice.
I like your video.can you forward me the workbook for practice.