# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save \$400. Learn More
Contributor III

## What is the meaning of attached set anaysis in qlikview?

Hi,

I have got this below set analysis and need to convert in sql. Please help me what is exact meaning of this:

Sum({(\$<[CNT_ID]={N}> + \$<[Returns Contract_Indicator]={N}> + \$<Contract_Indicator={N}>) * \$<RX={Y},YearMonthNumber={"\$(vCurrPeriodRange)"}>} [MI EXT\$])

I want to know that what the above expression mean.

Tags (1)
Labels (1)
• ### Set Analisys

1 Solution

Accepted Solutions
MVP

## Re: What is the meaning of attached set anaysis in qlikview?

In other words

([CNT_ID] = 'N' or [Returns Contract_Indicator] = 'N' or Contract_Indicator = 'N') and RX = 'Y' and YearMonthNumber = vCurrPeriodRange

6 Replies
Valued Contributor II

## Re: What is the meaning of attached set anaysis in qlikview?

HI,

PFB the usage of each component used in the set anlaysis expression shared by you:

1. + : Union

2. *: Intersection

3. [CNT_ID]={N}: where CNT_ID= N, similarly add the where conditions on these code snippets

4. YearMonthNumber={"\$(vCurrPeriodRange)"}: here vCurrPeriodRange is a variable defined in Qlik if you are using Qlikview Go to Variable overview and check the definition of the variable, if you are using Qliksense, when on edit window bottom right of the page there will be text x= click on it and check the variable definition

New Contributor

## Re: What is the meaning of attached set anaysis in qlikview?

One of the best practices I follow while preparing any report / dashboard is to provide a lot of context mykfcexperience. This typically makes a dashboard lot more meaningful and action oriented.

MVP

## Re: What is the meaning of attached set anaysis in qlikview?

In other words

([CNT_ID] = 'N' or [Returns Contract_Indicator] = 'N' or Contract_Indicator = 'N') and RX = 'Y' and YearMonthNumber = vCurrPeriodRange

Contributor III

## Re: What is the meaning of attached set anaysis in qlikview?

Hi,

Does it mean that the below expression is referring the sum of all possible values with condition applied  - Sum of all possible values with condition applied?

* \$<RX={Y},YearMonthNumber={"\$(vCurrPeriodRange)"}

Valued Contributor II

## Re: What is the meaning of attached set anaysis in qlikview?

it means sum([MI EXT\$]) with all the intersection and union conditions applied as explained by me and @sunny_talwar

Highlighted
Contributor III

## Re: What is the meaning of attached set anaysis in qlikview?

Hi,

Thanks for the Reply, I actually missed your previous post. Once again thanks for your help.