The QlikView and Qlik Sense Set Analysis Cheat Sheet

This is the first blog post at the new home of this QlikView blog, previously known as iQlik and hosted at http://iqlik.wordpress.com. After more than one year without posting any content, I’ve decided to continue my commitment to sharing QlikView ideas, tips and experiences and merge the iQlik blog content into the site of my consulting company, AfterSync.

All previous content posted at iQlik has been migrated to its new home. Additionally, you will notice that, when trying to access http://iqlik.wordpress.com, you will be redirected here in the hopes that people who had previously bookmarked a particular content or resource hosted on the previous location can still found it.

In the coming weeks, you will notice some additional changes to this new site and I hope to continue posting relevant QlikView content more frequently.

This time, I’m sharing with you a “QlikView Set Analysis Cheat Sheet”. A resource that I hope you can use as reference when struggling with set analysis expressions and as a quick guide to discovering the full power of set analysis.

You can download the PDF version of this cheat sheet by clicking on the download button at the end of this post.

Download PDF Version

Subscribe to receive new posts like this one and updates right in your inbox

[ratings]

About the Author: Miguel Ángel García

I have worked with Qlik tools for 10+ years and implemented BI solutions at multiple customers across a variety of industries. I’m author of the book QlikView 11 for Developers (several editions) and blogger at AfterSync (a.k.a. iQlik). I'm also the author of the Lean Data Processing online course, focused on building optimized data pipelines in QlikView and Qlik Sense.

12 Comments

Steve Dark June 22, 2015 at 8:03 am - Reply

This is an awesome resource, that I will be passing on to clients. Many thanks for sharing.
- Miguel Ángel García June 22, 2015 at 2:23 pm - Reply
  
  Thanks Steve! Glad you liked it.
Josh Duenyas June 22, 2015 at 3:21 pm - Reply

As always, thank you Miguel
It is always good to have a source where to go to when in doubt.
Yours makes life easier for us developers.
- Miguel Ángel García June 22, 2015 at 3:30 pm - Reply
  
  Thanks Josh!
Fatih June 22, 2015 at 1:39 pm - Reply

Hi Miguel,

thanks for sharing. – great post.

Could you please where I can find the download link of this?
- Miguel Ángel García June 22, 2015 at 1:47 pm - Reply
  
  Hi Faith, thanks for yout comment. For the pdf download, I’m asking people to help spread the word via the social share buttons. After you share this post on any of the social networks, the download button will appear.
  
  If, for some reason, you can’t or don’t want to share this post and stil want access to the PDF, let me know and I will send it to you via email.
  
  Best
  Miguel
Fatih June 22, 2015 at 1:54 pm - Reply

Hi Miguel,

already shared via twitter but no download button appears.

Would be great if you could provide the pdf via mail.

Thanks and regards
Fatih
- Miguel Ángel García June 22, 2015 at 2:14 pm - Reply
  
  No problem, I just e-mailed it to you.
  
  Best
  Miguel
Satish Dommeti July 1, 2015 at 4:46 am - Reply

Very helpful. Thanks.
Laura August 31, 2015 at 1:47 pm - Reply

I’m with a company that does not allow fb, twitter or google likes, but I can like on linkedIn as that is where I linked to it from. How can I get the pdf version ?
- Miguel Ángel García September 2, 2015 at 2:38 pm - Reply
  
  Hi Laura,
  
  Please download the PDF version from the following link: cdn.aftersync.com/Blog/QlikView-Set-Analysis-Cheat-Sheet.pdf
Jesus Gonzalez September 7, 2015 at 11:17 am - Reply

Mike,
Great Post…
Best Regards
Jesús