I have been working with QlikSense Business Cloud for a couple of days and get annoyed by some lack of features.These are impressions from a total newbie to qliksense (and cloud).
Excuse my bad English so bear with me. I have a simple case here. My customers request: Ingest daily data from Nasdaq and display some KPI's in different ways and it have to be in the cloud. Easy right? My first reaction was "Oh Great I can use QlikSense Business Cloud where I have data through Qlik data market".
Well, it wasn't so easy. Maybe I'm just ignorant or something and if you notice that I do something wrong please let me know.
First of all, qlik data market is "available" when you look through the account. Well you might think its available. But, the activation icon is greyed out. Why? there's no way at all to activate this. So I talked to the Qlik support who lets me know that "its not available through the cloud service - only Essentials data is available". So why show it?
Ok, no problems, lets use another source and use the REST-connector available. Did this, and it works fine. But, there is no possibility to add variables to the connection so my REST-calls have to be static. Great, now my customer needs to modify the call each day or....I "modify" the connection (with variables) in the script when doing the call to the source. Ok, so I made a dummy connection, because you have to open a connection first to modify it, and the script modifies the connection- this is how I think it works. Any way it works fine. I had to do some other stuff to refresh the security token etc but now I have the data. Tons av data!
Now the REST-call takes a couple of seconds - approx 30 sec - and I thought - "I really don't need the to load the old data" - so lets do some kind of incremental load. I'll save the data in a QVD with STORE INTO every day and load the app from there. Well, did somebody forget to tell me or write somewhere that STORE INTO doesn't work on the cloud? Yes they sure did because I could't get this to work and looking through the community I found out that other people had the same problem. Why is this anyway? I mean there's a folder to upload files right? Couldn't we use that folder to store the qvd? My solution have to load all data every time. That's it.
At this stage I'm pleased with the solution even though it could be better. Now the customer enters and says "This is great! Could you add the latest (spot) prices on top of the end of day prices?".... Hmm this means that the customer wants the already ingested daily rates but also the latest prices during the day on top - we need to refresh the app several times per day. In practice I need to add a REST-call to another resource (latest prices) but I cant load daily data from a previous QVD - cant save qvd's remember? - so I have to load all data, that is, all daily prices and the new spot prices every time! No worries, let's do this! But wait...You cant schedule the app to be loaded every hour (or other period) during the day (?)....The user have to right-click and update the app every time they want to have correct latest prices in the app. Not a big deal for me but the customer don't want to do that because they might "forget".
So, I don't know if I'm doing something wrong here, but I don't find another way than letting a robot (thanks RPA) trigger the reload of the app.
In summary - I found out that Qlik Data Market is not available, you cant have a dynamic REST-calls through the connector, you may not save your data from the script into a folder, and you cant reload the app more than once per day. On the other hand, in spite these issues, I could present a solution fast to the customer that didn't use Qlik before. But it makes me wonder what audience this service is targeting? Is it a user that only uploads excel sheets and plays around with it on the cloud?
The positive side of this is that I had a solution up and running very fast! and I can't think of other tools on the cloud that can be used for this.
Please let me know if I can do something better in my solution. As I said I have only been working with QlikSense Cloud for a couple of days and I'm sure things could be done better.