topic Re: Not able to understand the expression in QlikView

Not able to understand the expression

ferha_jafri — Fri, 11 Sep 2015 12:25:27 GMT

Hello Everyone,

I am not able to understand the * and + means in the expression mentioned below :

SUM({<Doorstep_Scan_Dt={'$(=Date(Max(Calendar_Dt),"DD/MM/YYYY"))'},Doorstep_Scan_Hour={'<=$(=hour(now()))'},Doorstep_Scan_Day={'$(=Date(Max(Calendar_Dt),'WWWWW'))'}>

(< Doorstep_Scan_Cd = {$(vDoorstepCodes)} > + < Eo_In_Cd = { 'EVNFS', 'EVNKS', 'EVNLA', 'EVNOC', 'EVNRT'} > +

< Eo_Out_Cd = {'EVNAA', 'EVNAI', 'EVNDN', } >)

} Mailpiece)

please help me in understanding the code as how qlikview is evaluating the above expression.

Thank you

Regards

Ferha

Re: Not able to understand the expression

sunny_talwar — Fri, 11 Sep 2015 12:28:39 GMT

This is from the set analysis guide:

Look at Page number 4 of the attached pdf

Re: Not able to understand the expression

sunny_talwar — Fri, 11 Sep 2015 12:29:17 GMT

I downloaded the above PDF from this location: Set Analysis: syntaxes, examples

Re: Not able to understand the expression

maxgro — Fri, 11 Sep 2015 12:30:51 GMT

from QlikView help

Operator	Description
+	Union. This binary operation returns a set consisting of the records that belong to any of the two set operands.
-	Exclusion. This binary operation returns a set of the records that belong to the first but not the other of the two set operands. Also, when used as a unary operator, it returns the complement set.
*	Intersection. This binary operation returns a set consisting of the records that belong to both of the two set operands.
/	Symmetric difference (XOR). This binary operation returns a set consisting of the records that belong to either, but not both of the two set operands

there are also some examples, search set analysis in the help

Re: Not able to understand the expression

ferha_jafri — Fri, 11 Sep 2015 12:41:20 GMT

Thanks but these I know but could you explain me in the above expression context as how qlikview evaluating the above expression as my understanding they both are same but in qlikview we are getting different ans for both the expressions

SUM({<Doorstep_Scan_Dt={'$(=Date(Max(Calendar_Dt),"DD/MM/YYYY"))'},Doorstep_Scan_Hour={'<=$(=hour(now()))'},Doorstep_Scan_Day={'$(=Date(Max(Calendar_Dt),'WWWWW'))'},

Doorstep_Scan_Cd = {$(vDoorstepComplianceCodes)}, Eo_In_Cd = { 'EVNFS', 'EVNKS', 'EVNLA', 'EVNOC', 'EVNRT'},

Eo_Out_Cd = {'EVNAA', 'EVNAI', 'EVNDN'} >} Mailpiece_Count)

Re: Not able to understand the expression

Anonymous — Fri, 11 Sep 2015 12:46:14 GMT

hi ferha,

please see:

QlikView Set Analysis Cheat Sheet

Re: Not able to understand the expression

sasiparupudi1 — Fri, 11 Sep 2015 13:05:23 GMT

one expression is summing Mailpiece and the other one is summingMailpiece_Count ?

you could try the expressions in a text box to see if you get the same totals or not

=sum({< Doorstep_Scan_Cd = {$(vDoorstepCodes)} > + < Eo_In_Cd = { 'EVNFS', 'EVNKS', 'EVNLA', 'EVNOC', 'EVNRT'} > +

< Eo_Out_Cd = {'EVNAA', 'EVNAI', 'EVNDN', } >)}

} Mailpiece)

=sum({<Doorstep_Scan_Cd = {$(vDoorstepComplianceCodes)}, Eo_In_Cd = { 'EVNFS', 'EVNKS', 'EVNLA', 'EVNOC', 'EVNRT'},

Eo_Out_Cd = {'EVNAA', 'EVNAI', 'EVNDN'} >} Mailpiece_Count)

hth

Sasi