Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
In other words
([CNT_ID] = 'N' or [Returns Contract_Indicator] = 'N' or Contract_Indicator = 'N') and RX = 'Y' and YearMonthNumber = vCurrPeriodRange
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
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.
In other words
([CNT_ID] = 'N' or [Returns Contract_Indicator] = 'N' or Contract_Indicator = 'N') and RX = 'Y' and YearMonthNumber = vCurrPeriodRange
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)"}
it means sum([MI EXT$]) with all the intersection and union conditions applied as explained by me and @sunny_talwar
Hi,
Thanks for the Reply, I actually missed your previous post. Once again thanks for your help.