topic Re: Set Analysis in QlikView

Set Analysis

vireshkolagimat — Fri, 13 Nov 2015 05:49:56 GMT

Hi,

can someone please explain the below expression. I got this expression from Qlikview demo apps.

Sum({<Year={$(=Max(Year)), $(=Max(Year)-1)}, Region={'NORDIC'} >} Sales / $(vCurrency))

Regards,

Viresh

Re: Set Analysis

rubenmarin — Fri, 13 Nov 2015 08:23:15 GMT

It shows the sum of Sales of the max year selected and the previous year of the region NORDIC, the result is divided for the variable vCurrency, wich I suppose contains the exchange rate for the currency selected.

In example, if you select year 2014, it show the sales for years 2014 and 2013.

Re: Set Analysis

Anonymous — Fri, 13 Nov 2015 08:32:23 GMT

This is giving you sales of NORDIC region for current year and previous year which is further divided by Currency variable to convert it into respective currency

Re: Set Analysis

maxgro — Fri, 13 Nov 2015 08:42:35 GMT

this is called set analysis

you can find some help

in the QlikView help

or here

A Primer on Set Analysis

Set Analysis: syntaxes, examples

Re: Set Analysis

engishfaque — Fri, 13 Nov 2015 10:30:38 GMT

Dear Viresh,

Your Set analysis interpretation is given below,

Return Sum of Sales divided by currency where Year is equal to Maximum Year as well as Last Year and region must be NORDIC.

I'm attaching beginner guide with this email as you can easily understand, read and write your own set analysis according to your project requirements.

Kind regards,

Ishfaque Ahmed