to follow, share, and participate in this socialgroup.
** Prerequisite – Install Qlik Sense REST Connector ** 1) Get guid from SharePoint list (Maybe your SP Administrator can provide this?) Navigate to the aspx page that contains the list: ... marmentrout5 stepped up like the champ he has always been and took the General Hospital data set to the next level by importing it into SQL Server and creating this BAK file. If you are a SQL Server user you c... As most of you know, I have a thing for Qlik Sense... But I want to share that I also love QlikView - everyone does at Qlik! Here's one of my favorite QlikView apps. Attached below you'll find a ZIP f... When creating your stored procedures be sure to “SET NOCOUNT ON;” On my SQL Server, the default setting is OFF so if explicit initialization is excluded the default behavior will create an error on... Sankey diagrams are a specific type of flow diagram, in which the width of the paths represent some quantity. These multidimensional visualizations help you to see flow and discover category relationships with a diffe... What happens when you load a raw data element that you need to do some work on ... but you also need to use that modified field value multiple times afterwards? Well you could do the Load statement Table: Load... Since launching a few weeks ago the folks at our fictitious General Hospital health system have been quite busy. General Hospital They were one of the first to purchase the CMS data set from Qlik Data Market a... If there is one thing I've learned in 12+ years working with Healthcare data ... COMPARISONS ARE CRITICAL. Telling end users to "make some selections and write down the KPI values, clear their selections and m... If you've used QlikView or Qlik Sense for more than a day you've probably found a use for the INLINE statement so you could created data on the fly instead of wasting time with a text file. Load * Inline [ Fiel... There are many times when the data files you receive will have no field values. In the data modeling world when a field is missing it value we say that it's value is NULL. There are times when you don't care a... This is probably the image that came to mind in the back of your head when you saw the word DUAL. But that's the beauty (or chaos) of the English language. Since the invention of the computer there has been a ... As you know Qlik's Associative Model provides easy association of tables by simply "associating" them using a common field name. If you have a lot of dimensional data you probably don't want to have a table po... It's almost unthinkable that just a few years ago many health systems were still using paper charts. As they began to roll out and adoption increased the types of available data sources we pretty much limited to the s... No problem if you know how to take advantage of Qlik's Apply Map functionality. If you've spent 2 minutes looking at the Encounters tables in most electronic health systems you know that they typically contain... The fictitious General Hospital data set includes quite a bit of information. Information that would be typical of an Inpatient healthcare system. But the goal of the General Hospital project goes beyond that data. We... This QlikView application does a very simple load of the General Hospital Layer 2 QVD files. The Layer 2 QVD files can be downloaded by clicking this link if you don't have them already. This QlikView application demonstrates one approach to data modeling for the raw data files for this fictitious General Hospital health system. The base files can be downloaded by clicking here.