Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question:
Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question:
I came across this post on the MicroStrategy Community tonight. It mentions a few of the Qlik and Tableau visualizations of famous paintings that floated around a few years ago. The images that were used back then, an example shown on the right, were black and white. Robert, the author of the MicroStrategy article, concludes that black and white is boring, and that it would be much better if the pictures were in color.
MicroStrategy to the rescue! Robert writes that as of version 10, you are able to do coloredvisualizations in MicroStrategy. He then goes on to demonstrate a few visualizations incolor! Take that QlikView and Tableau!
Overwhelmed by this spectacle of colors, I was already considering dropping my career in QlikView and moving into MicroStrategy when a thought popped into my head. Could it be that the author was mistaking the limitations of the data set (which only contained black & white values) for limitations of the tools? Perhaps QlikView (and Tableau) could also visualize pictures in color?
As you might have guessed from some of my earlier posts, I am a sucker for popular culture from the 80’s and 90’s. On this (apparently) most-depressing day of the year, let me offer you some light hearted, positive reading and share with you five of the motivational lessons that I learned from the 1984 classic The Karate Kid. Specifically, I will tell you how these lessons can be applied to learning Qlik, increasing your skills and expanding your knowledge. Or at least make you smile.
A quick summary of the plot for those not familiar with the movie (shame on you! 😉 ):
Daniel has just moved from New Jersey to California with his mom. He quickly discovers that it isn’t as great as he thought it would be. Daniel doesn’t fit in and a gang of bullies, who are all adept at karate, are making his life miserable. He then meets Mr. Myagi, a handyman who also happens to be a karate master. Mr. Myagi takes Daniel under his wing and teaches him karate, showing him along the way that karate (and life) are not always about power and strenght. Can Daniel overcome his bullies in the All-Valley Karate Championship? (spoiler: yes he can!)
I recently read an interesting post by James Richardson over at the Business Discovery Blog: Wizards vs Scripts. In the post James makes the case that QlikView scripting is not old-fashioned or too hard, but is evidence of the power of QlikView as a platform.
Let me first state that I love QlikView scripting. I’m a guy who writes script for fun. I also agree that scripting offers much more flexibility than a visual solution ever could. With those things in mind, I would like to present a different viewpoint: I think that QlikView places too much emphasis on scripting. In my opinion, the default approach should be much more visual.
As promised in the previous post, today I have a tip for you that is of real, practical use.
Management summary: Ctrl + Shift + S overrules all conditional show expressions making every hidden sheet and sheet object visible.
Full story: Condtional show expressions are used in QlikView to show or hide a sheet or sheet object depending on if a predefined condition has been met. While this is extremely useful functionality to make your applications more user-friendly, it can be a real hassle during development.
If you want to edit a sheet or object when its show condition has not been met, you either have to make a selection that matches the condition, or you have to dig deep into the menu (Settings | Document Properties | Security | Show All Sheets and Objects) to disable, and when you’re done re-enable, conditional display. We all have better things to do with our time, for example reading blog posts that are way longer than they need to be.
Fortunately, in QlikView Desktop (‘classic’ view, not WebView) there is a shortcut: Ctrl + Shift + S overrules all conditional show expressions making every hidden sheet and sheet object visible. Now you know.
With over 80% of data* having a spatial component,geographical analysis can add a powerful new dimension to almost any reporting environment. In the coming time I intend to review the various methods of extending QlikView with geographical analysis capabilities, describing how to apply these methods and what their pro’s and cons are.
Read on to see the options I have identified so far. read more »
I came across 
As you might have guessed from some of my earlier 
I recently read an interesting post by James Richardson over at the Business Discovery Blog: 
As promised in the 
