QSDA Release 2.6 Brings Customized Flag Levels
Qlikview Cookbook | Recipes for Qlikview Success
by Rob Wunderlich
3M ago
QSDA Pro 2.6 is available now and a new feature is Flag Levels. Each flag type is assigned a level of Info, Warning or Error with a matching color. Color helps you focus on what’s important. Flag Levels may be customized and refined for your requirements using the new Admin > Project Config page. QSDA 2.6 also adds three new flags: “Calculated Dimension“.  The default level for this flag is Warning.  “No Application Thumbnail“. The default level for this flag is Warning.  “Missing Theme“. The default level for this flag is Error. A missing theme can occur when moving an App ..read more
Visit website
Charts from the 1900 Paris Exhibition
Qlikview Cookbook | Recipes for Qlikview Success
by Rob Wunderlich
4M ago
Summary: For the data viz nerds among us, I share my fascination with a groundbreaking data viz project at the 1900 Paris Exhibition. In Tim Harford’s excellent book “The Data Detective: Ten Easy Rules to Make Sense of Statistics” the author mentions a set of infographics produced by W.E.B. Du Bois and assistants for the 1900 Paris Exhibition. The “Exhibition of American Negroes” is a powerful collection of photographs and data visualization that provide a strong counter to racist propaganda and ignorance of the time. I encourage you to explore the entire contents of the exhibit, but in this p ..read more
Visit website
Masters Summit for Qlik Cloud
Qlikview Cookbook | Recipes for Qlikview Success
by Rob Wunderlich
4M ago
Masters Summit New Qlik Cloud Track! The Masters Summit Team is developing all new courses for 2024. The new content is focused on: Qlik Cloud (perfect for clients who are on or moving to cloud already, or evaluating a migration). New capabilities in the platform, like AutoML, Automation, etc. Before we get too far down the road, we want your input to gauge interest. We are opening pre-registration for our 2024 conferences: Vienna, Austria – October 02-04 Pre-register for Vienna now Philadelphia, USA – November 04-06 Pre-register for Philadelphia now If you or o ..read more
Visit website
Using Attributes in QVD Files
Qlikview Cookbook | Recipes for Qlikview Success
by Rob Wunderlich
7M ago
Here’s a fun Friday post. As I was updating my incremental load materials for the upcoming October/November Masters Summit for Qlik, I ran across an old note about creating “Attributes” in QVDs using Tags. Due to a bug in QVD generation I couldn’t implement the idea at the time. But the bug is long since fixed so here I present the general idea of “QVD Attributes” (my name, not an official Qlik thing). We can assign Tags to Qlik Tables using the script TAG statement: Tag TABLE TranData with 'MaxId=$(vMaxId)'; Tag TABLE TranData with 'Source=Salesforce'; If the table “TranData” is subsequently ..read more
Visit website
Guest Speaker for Dublin Masters Summit
Qlikview Cookbook | Recipes for Qlikview Success
by Rob Wunderlich
7M ago
I’m pleased to announce that Brian Booden will join us at the October Masters Summit for Qlik in Dublin, Ireland. Brian is a seven (!) time Qlik Luminary / Partner Ambassador, co-host of The Data Mix, and a well known Qlik and Analytics expert. Brian will share some inside tips on using Qlik Application Automation and I expect a few interesting tricks. I’m hoping he shows off the capabilities of his WhatsApp for Qlik integration! Masters Summit for Qlik is the premier Qlik Sense & QlikView advanced education event. In three packed days of lectures and hands on exercises, you’ll learn from ..read more
Visit website
Creating Time Groups in Your Data Model
Qlikview Cookbook | Recipes for Qlikview Success
by Rob Wunderlich
8M ago
I frequently create Date groups in my Qlik apps to facilitate selections like “Yesterday” or “Last Week”. Some years ago I published a pattern for creating Date groups in the Recipes section of QlikCookbook.com and it’s been a very popular download. I’ve responded to a few requests on Qlik Community looking to do the same thing for Time groups, so I decided to publish a recipe for Time Grouping as well. The recipe demonstrates selecting ranges such as “Day Shift”. Selecting by Time Group How do we create ranges that map to our data? In the script, create a Range table that defines range Names ..read more
Visit website
QSDA Pro 2.5 Brings Extended Expression Validation
Qlikview Cookbook | Recipes for Qlikview Success
by Rob Wunderlich
10M ago
Summary: Set Modifier field names and Set Identifiers are not validated by Qlik syntax check. QSDA Pro 2.5 validates everything and raises an “Unrecognized Name” flag for invalid names. QSDA Pro syntax checks all expressions in a Qlik App using the Qlik syntax checker. You’re familiar with the Qlik syntax checker. It’s the message at the bottom of the expression editor that tells you your expression is “OK”. The syntax checker is also good at telling you when the expression has an error, although it’s not always specific about the problem. QSDA Pro, using the Qlik API version of syntax check ..read more
Visit website
Qlik App Performance Tuning — March 29
Qlikview Cookbook | Recipes for Qlikview Success
by Rob Wunderlich
1y ago
My Masters Summit for Qlik colleague Oleg Troyansky will be presenting his always valuable “Performance Tuning” course on March 29 as part of our “Masters Summit at Home” online series. Oleg will do a deep dive into the causes and corrections for Qlik App performance issues. He’ll explain the why of good and bad performance while explaining important Qlik Engine concepts and demonstrating best practices. I highly recommend this course. Oleg will demonstrate available performance tools including my favorite — QSDA Pro. As part of the class each student will receive a trial license key for QSDA ..read more
Visit website
Mind the Concat() sort-weight
Qlikview Cookbook | Recipes for Qlikview Success
by Rob Wunderlich
1y ago
Summary: While looking into long expressions I noticed that the optional sort-weight argument has an impact on the distinctness of Concat(distinct…). Incorrect use of sort-weight can generate bloated expressions containing redundant code. In my work tuning Qlik Apps I sometimes encounter very long expressions. An expression many thousands of characters long can be difficult to debug or comprehend the expression goal. To help in working with long expressions I’ve added an Expression histogram and an Expression Decoder feature to my QSDA Pro product. (These features are currently in beta, genera ..read more
Visit website
The New Qlik Simplified Authoring Mode
Qlikview Cookbook | Recipes for Qlikview Success
by Rob Wunderlich
1y ago
Qlik has implemented a new “Simplified Authoring” experience in the SaaS (Cloud) environment. It’s available as an optional preview now and will be implemented for all SaaS tenants in mid-August. I won’t describe the new features as they are well described here. If you haven’t already, I recommend you read the post and then come back here for my comments. I think this is really great work and a significant improvement to the chart authoring experience. It not only makes it easier for newbies to create charts, I prefer using this interface in most cases. What do I like about it? Moving the data ..read more
Visit website

Follow Qlikview Cookbook | Recipes for Qlikview Success on FeedSpot

Continue with Google
Continue with Apple
OR