Power BI DAX Functions

Logical functions Logical functions act upon an expression to return information about the values or sets in the expression. For example, you can use the IF function to check the result of an expression and create conditional results. In this category Function Description AND Checks whether both arguments are TRUE, and returns TRUE if both…

Read More

Mapping Tables in QlikView

Mapping table in QlikView is a table, which is created to map the column values between two tables. It is also called a Lookup table, which is only used to look for a related value from some other table. With Joining two table you can refer data of one table in another table. By using…

Read More

Comparison between SAS BI vs. Tableau

Following are the Comparison of popular BI tool SAS and Tableau. BI Product SAS BI Tablueu BI OverView SAS Business Intelligence is a part of SAS Enterprise Solutions. It combines business intelligence and analytics to discover and collect enterprise-level data. With SAS Business Intelligence, you get user-friendly, self-service business intelligence tools and solutions. On top…

Read More

Single Configurator of Qlik Sense Dev Hub

The Single configurator is a tool that provides an easy way of building light weight mashup pages without writing any code. It enables a Qlik Sense object, which is in form of an URL. The Qlik Sense object is normally a visualization of an existing app of Qlik sense desktop. It could be a a…

Read More

Incremental Extract in Tableau

Incremental Extract Incremental extract is an approach where rather than refreshing the entire extract, you can configure a refresh to add only the rows that are new since the previous time you extracted the data. For example, you may have a data source that is updated daily with new sales transactions. Rather than rebuild the…

Read More

QlikView IntervalMatch Function

QlikView IntervalMatch: IntervalMatch is a powerful function used to match distinct numeric values to numeric intervals. It is useful in analyzing how the events actually happened versus the planned events. The example of a scenario where it is used is in the assembly lines of the production houses where the belts are planned to run…

Read More

How to get Rolling Month using Set Analysis in Qlik

I have a requirement to retrive data from Last 6 Month to Till date. How we can achieve this? Yes! we can achieve this by using Qlik Sense Set Analysis. Step1: You have to create a variable say “vLastSixMonth” in Qlik Sense Step2: You need to define the dynamic methods in variable. Such as AddMonth(YourDateField,…

Read More

Overview of Qlik NPrinting NewsStand

Introduction to Qlik NPrinting NewsStand Qlik NPrinting NewsStand is the web portal for users. In the NewsStand a user can see the reports he/she is authorized to view, download and it is possible to trigger reports refresh. In this case they will be published in the NewsStand. Opening NewsStand The NewsStand web portal uses the…

Read More

Learn Power BI DAX in 30 minutes

Learn Power BI DAX in 30 minutes What is DAX in POwer BI? Data Analysis Expressions (DAX) in power BI is a set of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values. Stated more simply, DAX helps you create new information from…

Read More