Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ananyaghosh
Creator III
Creator 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.

 

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

In other words

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

View solution in original post

6 Replies
anushree1
Specialist II
Specialist II

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

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.

sunny_talwar

In other words

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

ananyaghosh
Creator III
Creator III
Author

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
Specialist II
Specialist II

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

ananyaghosh
Creator III
Creator III
Author

Hi,

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