Looking at your Buttons and Sliders, I'd say - QlikView, not Sense (unless the February version introduces that, I haven't seen it yet...)
Also, if you are a newbie, it's not going to be an easy task in two days...
www.masterssummit.com - take your QlikView skills to the next level!
Wow ! Appreciate the Qwik comment ! Based on your statement I'm assuming that the user can add/remove/update data in QlikView, i.e. not just view it
Re: newbieness, that's what I've been fearing. I've watched many tutorial videos, and I'm expecting to just follow a bunch of examples until I've learned what all the objects are and how they relate to each other. I was hoping to find an example of how to take an existing simple Excel "Application" and re-create it in QlikView. (macros, hidden sheets, etc).
If you know of any such examples or tutorials or discussions, I'd me much obliged to learn.
BTW, I have extensive experience in SQL and VBScript .. I just havent gotten my head around the equivalents between Excel's objects and Qlik's, e.g. Sheets in Excel vs Tables? in Qlik ? Hidden sheets or Class objects? UI events and code behind, etc.
Anyway, this looks like it's going to be a lot of fun - even if it takes too long to get up to speed ;-)
Let me address your questions one by one:
<<<Based on your statement I'm assuming that the user can add/remove/update data in QlikView, i.e. not just view it>>>
Not quite... What I meant was that in QlikView you can use buttons to cause Actions to happen, and you can use Input Boxes and Sliders to set variables for what-if simulations. None of that is supported yet in Sense (again, I haven't seen the latest release yet, maybe it's there...)
<<<I was hoping to find an example of how to take an existing simple Excel "Application" and re-create it in QlikView. (macros, hidden sheets, etc). >>>
That, unfortunately, doesn't exist. There is no conversion path from Excel macros, formulas etc... to QlikView.
<<<Anyway, this looks like it's going to be a lot of fun - even if it takes too long to get up to speed ;-) >>>
That's almost guaranteed!
In Qlik Sense you can drag and drop your Excel file to pull in all data for quick and easy visualizations.
If you are looking for something that the user can add/remove/update visualizations, I would recommended Qlik Sense. The library feature allows users with less experience to update the dashboard without scripting.
Have you downloaded both products and played around yet? There are several free videos on how to use Qlik Sense here:New to Qlik Sense Videos
There is a more involved developer tutorial located here: Qlik Sense Comprehensive Developer Tutorial
There are free QlikView videos here: QlikView Free Training - Business Intelligence (BI) Reporting Software Solutions | Qlik
I hope this information helps.
Thanks Caroline - actually I don't need the user to make new visualizations - but they do need to be able to modify data and see the results in a stacked bar chart.
It would be nice to allow them to use sliders to modify (add/change/delete) data and see the results immediately.
I.e. they need to be able to add/delete rows and columns, and update values in the crosstab style grid, and have the results displayed in the chart as well as in another similar crosstab grid.
Assuming that I can use a slider to adjust values in cells, if the user adds a new column, a new slider needs to be created to adjust the value of the cell in that column (on a particular row). If you refer to the screenshot, this would mean the user adds a new Criterion (in a new column) , and the app would add a corresponding slider.
I tried to install Sense (desktop), but it appears my operating system (64-bit Windows Server R2 SP1) is not supported. According to Adam in sales, it only works on non-server Windows 64 bit OS.
After a bit of searching, I did find and download something that might work at Index of /download/Qlikview 11/QV 1120 SR10 12742/Server/Windows 2012 but I haven't tried installing yet. I might spend time playing with QlikView first.
Thanks for the links .. I will be watching the comprehensive one for sure.
Yes, I played with Sense, and even described it in my new book QlikView for Business that's coming out in April! I just haven't seen the most recent version that should be out or almost out (?)
Based on the user requirements for this particular project, it looks like QlikView might still be a better choice.
I am happy to announce that Qlik Sense release 1.1 (available as of February 23, 2015) now features a pivot table. The new way Qlik Sense visualizes a traditional pivot table is seriously cool.
Here is a short video that shows all new features with Qlik Sense 1.1. Qlik Sense 1.1 - New Features Highlights - YouTube
I hope this helps.