Last 18 months report issues QlikSense Desktop vs QlikSense Server
Back in April when my company was considering going with QlikSense, I downloaded QlikSense Desktop (version 2.2) to play around with and figure out viability. Back in late May/June, my company installed QlikSense Enterprise in house (version 2.0.9). At times I have developed on the server in my local work area. At other times, I have played around with things in my local Desktop copy before migrating my work up to the server.
I recently came across something that I am struggling with, that I appear to have gotten working in my Desktop environment, but cannot get working on the Enterprise Server environment.
I was working on a "last 18 month report (shows current month and the previous 17 months)" with sales by revenue and sales by units. I have worked on both bar charts and pivot tables for the business. My dimensions are MonthYear (figured out in my master calendar) and ProductSubType (a refinement of our two main product lines). My measure is either Sales (ie, revenue) or Units (ie, units sold). We are basing both off of InvoiceDate as that denotes an actual sale in our case. I will give an example of the sales (revenue) set analysis I am using. DealerCostUSD is the value I am aggregating on.
Another note before I go further....I have hooked my local QlikSense Desktop up to pull from backed up copies of production data. QlikSense Server pulls from the live production databases. In either case I am viewing the same data.
To continue, when I use that above, I get a populated bar chart (or pivot table). I see values for the last 18 months. When I use the same on the QlikSense server, I get nothing. No data. Nothing. No bars. No data.
I am not sure what is wrong? Since we are using the "upgrade track" for the server (ie, 2.0.9) and the desktop versions follow the "feature track" (ie, 2.2) is this a bug that is fixed in my local desktop or a feature not yet implemented unless we move our server to version 3.0? Do I have something wrong with my set analsyis (then why would it work in Desktop and not server???) Is there a workaround I could use? Thoughts?