topic I thought QlikView was supposed to be easy to learn in QlikView

I thought QlikView was supposed to be easy to learn

Fri, 13 Nov 2009 09:56:06 GMT

Hello Everyone,

Of course I'm a newbie not only to this product but from a technical perspective BI in general. I'm not finding this product to be user friendly at all. Perhaps it's just the newness of it all but I'm wondering did anyone else fell this way at the start?

I thought QlikView was supposed to be easy to learn

Fri, 13 Nov 2009 15:55:02 GMT

Yes, I felt the same but when you try a lot you will get the hang of it. Through this forum you can get much help.

Succes!

I thought QlikView was supposed to be easy to learn

agsearle — Fri, 13 Nov 2009 16:28:21 GMT

I started to use Qlikview just over a year ago, and had no help apart from here on this forum. I would have been lost without all the very helpful people here!

Not a week goes by without me learning something new, my reports are getting better and better. Just stick with it, worth it in the end.

I thought QlikView was supposed to be easy to learn

Fri, 13 Nov 2009 17:02:35 GMT

Couldn't agree more. I started using it 3 days ago............

I thought QlikView was supposed to be easy to learn

stevedark — Fri, 13 Nov 2009 18:13:01 GMT

Hi There,

I found that following through the tutorial that gets put in the folder C:\Program Files\QlikView\Tutorial (provided you do a full install with default options) was a brilliant start point. I got through this in a couple of days and was able to build simple applications at the end of it. Being able to use some of the advanced features only comes with time and experience. As others have said though, this forum is a good place to find answers, and ask questions.

All the best with it. I am sure you will find it worthwhile putting the effort in.

Cheers,
Steve

I thought QlikView was supposed to be easy to learn

Qlik_Trigg — Fri, 13 Nov 2009 21:37:05 GMT

All

This is an illuminating discussion and one we are keen to keep learning from. Steve, glad that you found the tutorial helpful. It probably should have been easier to know where it was and how to get to it. We want to add content to this 'Getting Started' forum that can also help anyone starting with QlikView. Did you have a chance to look at any of the short videos available? Are they useful? Should there be others that focus on certain topics?

Let us know your thoughts

Regards

John Trigg

Global product Manager - QlikView Developer

I thought QlikView was supposed to be easy to learn

Fri, 13 Nov 2009 22:16:21 GMT

I remember that I was completely lost until I went through the tutorial when I started with Qlikview. The tutorial became sort of an "aah" experience and after that I had the basic conceptual understanding of the product to go into a trial-and-error learning mode.

I thought QlikView was supposed to be easy to learn

johnw — Sat, 14 Nov 2009 08:07:04 GMT

I'm not sure if it means anything, but I found it user friendly from the start. My very first exposure was going through the tutorial on my own. I don't remember that being difficult. Shortly after that, we had a consultant in to teach a class on it for a couple of days to the intended developers. I remember being bored in the class and moving ahead to experiment with things on my own, read in my own data instead of sample data, that kind of thing. But all of this was years ago, so it's possible that it was more confusing at first than I remember.

Mind you, I've always had a love/hate relationship with QlikView. In general, I find it to be an extremely clever product that does so very many things right. But there are also aspects of how it was designed that make certain things unnecessarily difficult and occasionally seemingly impossible. And it seems to go through periods of instability and bugs, perhaps because so many new features are being rushed in so quickly.

I thought QlikView was supposed to be easy to learn

Anonymous — Sat, 14 Nov 2009 10:37:22 GMT

I sometimes compare using QlikView to writing. You can learn a few letters and write simple phrases quickly. You need some experience to write long phrases and short stories, and a good deal of talent for novels. And, only few who are able to create something like "King Lear" or "War and Peace". Oh, and they are not always the same people who invented letters.
Don't be upset if you're are not there yet...

I thought QlikView was supposed to be easy to learn

Sat, 14 Nov 2009 19:24:18 GMT

Im into it for about 6 weeks now. Im finding if Im playing with a concept its fine, pivots,straight pivots charts and general functionality its fine but if your trying to produce something releaseable to production its a differant matter.

The backend throws up issues around performance loading, persisting filtering and joining Qvds , Incremental Loads, optimised loads and dimension handling. and the Script window being modal is really irritating!

The front end is a bit easier as its all in property boxes (the modal dialogs are just as annoying here though), Im often finding the option I want is greyed out and its not clear Why (to me anyway!), set analysis is potentially great though i can see it becomming complex quickly.

Im currently struggling with Sorts (about as basic an operation as you can get) im sorting descending and getting ascending, im unable to sort a text branch code in numeric order correctly in a cyclic group that is used on a list box filter (a seperate post is on its way to forum for some more excellent assistance .)

II am also struggling with bookmarks not behaving as i would expect from reading the help

Its a bleeding edge product and at the moment im the one doing a lot of the bleeding ... The forums an excellent resource as has been said before in this thread. perhaps QlikView support can monitor it and assist a bit more to improve this aspect of the product

Regards.

I thought QlikView was supposed to be easy to learn

Anonymous — Sun, 15 Nov 2009 03:09:43 GMT

It depends on your BI and SQL background. I was able to demo a Sales application within 24 hours. But others I work with took considerably longer, primarily with the scripting. You'll get it, then you'll fall in love!

I thought QlikView was supposed to be easy to learn

johnw — Tue, 17 Nov 2009 00:25:16 GMT


Brian wrote:It depends on your BI and SQL background.

Good point there. I have a decent SQL background, but not a BI or interface-design background. My main prior experience was as the guy designing and/or coding the complicated background pieces of software, not the front end part that the users are dealing with. So I very quickly had data loaded in and was making some basic charts, and even writing some macros, but it took some book reading and some practice before I was producing things like professional-looking dashboards.

I thought QlikView was supposed to be easy to learn

Wed, 12 May 2010 15:33:30 GMT

I'm also new to this, and I'm gobsmacked by the lack of clarity.

I've got a lovely .csv of data. (International cricketers by country, date of birth etc etc, for those who are interested in analysing the impact of birth month on sporting success!). I'd like to use it to test out Qlikview

I expected to be able to find a button marked 'upload data', then to be able to dive immediately into sorting, averaging, showing means, subtotals, comparing one country against another and so on. I'm (a) stuck at first base - can't even work out how to upload the stuff and therefore (b) I'm not using it. You could add (c) clearly v stupid, but something feels wrong! I'm an experienced excel user, so if I'm stuck, I'm guessing that Qlikview is losing approx 75% of the sales it could be getting. Key indicators for you to check:

1) What is your conversion rate of trials to sales?

2) What is your conversion rate of trial downloads to using more than twice?

I'm a little embarrassed to say that I haven't looked at the video tutorial. My excuse? I haven't got an afternoon to spare, and I can get on with things on excel for the moment. I'm aware this will sound wimpish, but if there are lots of products saying 'you just need to invest 2-3 days to get the basics' then I will simply wait until one of them gets easy enough to use out of the box... comments welcome

sincerely

A Late Adopter

I thought QlikView was supposed to be easy to learn

Wed, 12 May 2010 16:12:29 GMT

I have about 3 years experience of using QlikView but as with John above, I don't remember it being too difficult to get moving on it, and I was immediately faced with existing complex load scripts to understand.

I am, to say the least, not a QlikView evangelist but I do believe that the product is very easy to implement and it is possible to have applications up and running in a couple of days.

As for the point above, loading data from a CSV into qlikview could not be easier, I have just done it and not counting the saving of the qvw application it took precisely 8 mouse button clicks! I'm not sure I have ever used an application that makes life that easy.

I do of course accept that I am speaking now after 3 years of experience, however, one thing I did do at the start was to look through the tutorial (briefly) and hand pick a couple of the training videos to watch. I'm not sure there are many applications out there where you can get stuck in and produce something meaningful without allocating some time to learning, you seem to be forgetting that you are using Excel because you have some experience with it, and therefore it's easier.

So......... what does "out of the box" really mean?

If I can get data from a dat source into Qlikview in 8 clicks of the mouse, is that not "out of the box".

I agree with John, there are issues with QlikView, but ease of use and "getting started" is most certainly not one of them.

I thought QlikView was supposed to be easy to learn

Wed, 12 May 2010 16:13:49 GMT

Your points are valid and worth noting. However, I would encourage you to review the getting started online tutorials as they are critical in gaining a basic knowledge of how QlikView works. I too was exactly where you are initially and the tutorials helped quite a bit. While QlikView may be "easy" to learn the basics, a greater degree of effort and experience is needed to gain an advanced level of understanding of the power behind this tool. Unfortunately the marketing behing QlikView tends to wieigh heavily on the ease of use, time to value and overall simplicity from both the end user and developer perspective comparative to other products on the market.

Best of luck!

I thought QlikView was supposed to be easy to learn

Wed, 12 May 2010 16:15:34 GMT

And just for completeness, the sequence to do it is:

1. Open QlikView

2. Click on Load script icon (or press Ctrl-E, or go to Menu-Edit Script)

3. Click on Table Files

4. Locate & select you CSV file

5. Click on Finish

6. Click on OK

7. Click on Reload Icon (or press Ctrl-R or go to Menu-Reload)

It will ask you to save the file if it doesn't already have a name, then you have the data.............

I thought QlikView was supposed to be easy to learn

Anonymous — Wed, 12 May 2010 16:16:15 GMT

QlikView IS very easy to learn compared to other BI products. But, the manual is not well written and the steps to creating your first document are not clear, certainly not obvious to a non BI user. If it had a start-up Wizard that would be a great improvement.

When I loaded my first data I DID have to read a little in Help in order to understand what I needed to do. However, once I figured that out and had used the Layout>Select Fields function, I quickly learned that QlikView is by far the fastest and easiest dashboard tool. It took another search through Help to figure out how to calculate averages, sums, counts, percentages, etc., in Chart objects. Once again, though, after creating the first one I was blown away at how easy is was. My first Doc took two days to create from QV install to sharing with others.

After working in QV for 2.5 years, I'm still trying to figure out many of the advanced features. I often refer to the manual but occasionally I've had to get expert help for thorny problems.

I thought QlikView was supposed to be easy to learn

johnw — Wed, 12 May 2010 17:46:59 GMT


gilesslinger wrote:I'm also new to this, and I'm gobsmacked by the lack of clarity...
I'm an experienced excel user...
if there are lots of products saying 'you just need to invest 2-3 days to get the basics' then I will simply wait until one of them gets easy enough to use out of the box...

I do think I understand exactly where you're coming from. I downloaded an evaluation version of Tableau, just out of curiosity for how it compared. I briefly glanced through some of their sample applications, failed to grasp in less than 5 minutes how to load in my own data, and moved on. I never got it working, and the trial period expired. I'm willing to bet that Tableau is no harder to use than QlikView. But I didn't NEED to learn how to use it, so since I couldn't learn it in 5 minutes, I gave up. I'm sure there are people evaluating QlikView having the exact same experience. Some of those people probably do represent lost sales opportunities.

Excel IS an excellent product, and the "BI tool" of choice for a large number of companies. It has been around forever, and it has had lots of time to get things right. Many of us have grown up on spreadsheets, so they just "feel right" to us when using them. But I'm also pretty confident that if you took someone that had never used spreadsheets before, and sat them down in front of Excel, they would not find it "easy enough to use out of the box". It would probably take them two or three days of experimentation, reading or instruction to figure out what was going on, and it would take them much longer than that to master the product.

So I don't think the learning curve of QlikView is much different than that of Excel. Both are excellent products. Both take a few days to get the hang of them. Just most people invested those few days in Excel so long ago that it may seem like something they've always known, something entirely natural.

Now MAYBE BI tools will eventually reach your standards of "easy enough to use out of the box". Certainly ease of use is something everyone is working on, and would like to improve in their products. Let's say they finally get it just that easy after ten or twenty more years, kind of like the evolution of the word processor or spreadsheet from very clunky to the smooth products they are today. Companies that wait ten or twenty years to adopt BI because it's not "easy enough to use out of the box" are wasting an excellent opportunity to improve themselves. All it takes is a little investment in their future.

I thought QlikView was supposed to be easy to learn

Wed, 12 May 2010 21:03:48 GMT

Nigel, great reply, thank you.
And to all the other respondents, it;s been very useful to hear your views. Thank you for the encouragement and suggestions, and I will give it another go..!

I thought QlikView was supposed to be easy to learn

stevedark — Wed, 12 May 2010 21:31:07 GMT

Hi there,

Regarding the comment that it would be good to have a wizard for going from a standing start this is being added in QlikView 10. I have recorded a video of it in action which can be viewed here: http://bit.ly/acCUEp .

There is also another video on my YouTube channel that looks at sourcing data from a web site in just a few clicks.

Hope these videos are of assistance.

Regards,
Steve