Using Set analysis Excel variables in Qlik Sense

[vikasmahajan]

Using Excel variables in Qlik Sense

Approach :  Use excel sheet for loading all set analysis in Qlik Sense environment and use those variables as a expression in Qlik Sense Charts.

Environment

• Qlik Sense

Resolution

Simple approach to load all set analysis expressions using excel sheet and maintain at one place and use the same for expressions in Qlik Sense Charts.

Find attached excel sheet containing YTD, Current YTD, Growth % formulas in excel sheet same has been loaded in QS & used in Chart as a variable.

[Nadia_Coelho]

RESOLUTION

Informatec (Innovative Business Intelligence Solutions - Informatec) may have solved this problem with a product called iVIEW Library a central Library for all Qlik applications.

iVIEW Library is a standalone web application for managing and deploying master data items and content definitions for Qlik to define your data, enrich it and deploy it.  

Within the iVIEW Library you can import from EXCEL by using a predefined list of variables and expressions. Once you import this excel sheet into iVIEW Library, you can refine the contents and re-use them in Qlik Sense.

This enables you to get the most from your existing content, analyze potential conflicts and build a work set to speed up migration.

For more information visit iVIEW Library - iVIEW and request a demo today!

[Ciya]

Which is the best practice for handling expressions in QlikSense: creating master measures or declaring variables?