Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
ananyaghosh
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)
1 Solution

Accepted Solutions
Highlighted

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
anushree1
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

Coatess1
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.

Highlighted

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

ananyaghosh
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)"}

anushree1
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 

ananyaghosh
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.