topic Re: difference of 2 expressions in QlikView

difference of 2 expressions

arethaking — Wed, 25 Nov 2020 16:16:04 GMT

1) Sum( {$<Year = (Year + {“20*”,1997}) – {2000} >} Sales )

2) Sum( {$<Year = Year + ({“20*”,1997} – {2000}) >} Sales )

What is the difference between 1 and 2?

Re: difference of 2 expressions

kumarkp412 — Thu, 28 Jul 2016 07:57:07 GMT

In the first expression

First, it will add the current year to 20 series years plus 1997 and then it will subtract it will 2000 ,then based on the resultant value of year it will calculate the sum of sales.

In the second expression

First, it will do the subtraction of 20series plus 1997 to 2000 , then resultant value is added to the current year and based on the final year value it will calculate the sum of sales.

Thanks

Kumar

Re: difference of 2 expressions

Frank_Hartmann — Thu, 28 Jul 2016 08:02:05 GMT

sum( {$<Year = Year + ({“20*”,1997} – {2000}) >} Sales )
returns the sales for the current selection but with additional selections in the field “Year”: 1997 and all that begin with “20” – however, not 2000. Note that if 2000 is included in the current selection, it will still be included after the modification.

sum( {$<Year = (Year + {“20*”,1997}) – {2000} >} Sales )
returns almost the same as above, but here 2000 will be excluded, also if it initially is included in the current selection. The example shows the importance of sometimes using brackets to define an order of precedence.

Re: difference of 2 expressions

arethaking — Thu, 28 Jul 2016 08:11:16 GMT

Will both give same results?

Re: difference of 2 expressions

Frank_Hartmann — Thu, 28 Jul 2016 08:16:34 GMT

no, in the second example the 2000 is excluded whereas in example 1 it is included!

Re: difference of 2 expressions

Anil_Babu_Samineni — Thu, 28 Jul 2016 08:36:50 GMT

1) Sum( {$<Year = (Year + {“20*”,1997}) – {2000} >} Sales )

* Means What ever value after 20-- from Year field

2000 --- 2016 and 1997 and then remove the 2000 Data from Year Field the value of Sales

2) Sum( {$<Year = Year + ({“20*”,1997} – {2000}) >} Sales )

Still Confusing here. Need more analysis about this

Re: difference of 2 expressions

sunny_talwar — Thu, 28 Jul 2016 09:09:07 GMT

Are these expression even working? I have a strange feeling that both of them might not be working, but I may be wrong.

Re: difference of 2 expressions

Frank_Hartmann — Thu, 28 Jul 2016 09:14:13 GMT

But they are described in the QV help, so they should work 🙂

Re: difference of 2 expressions

sunny_talwar — Thu, 28 Jul 2016 09:15:12 GMT

Oh really? Would you be able to guide me to location of these expressions. I would love to understand the syntax

Re: difference of 2 expressions

Frank_Hartmann — Thu, 28 Jul 2016 09:21:37 GMT

search for : {set_identifier<set_modifier>}

in QV help. There is only one hit. you will find the expressions within that page 🙂

Re: difference of 2 expressions

sunny_talwar — Thu, 28 Jul 2016 09:28:54 GMT

When I search that the only useful link is this:

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/SetAnalysis/set-modifiers.htm‌

I might be missing it, but not sure where is the above expression in the set of example?

Re: difference of 2 expressions

Frank_Hartmann — Thu, 28 Jul 2016 09:33:25 GMT

ahhh, you have to search in the inbuild qlik help

Re: difference of 2 expressions

sunny_talwar — Thu, 28 Jul 2016 09:37:22 GMT

Using QlikView 12, so it takes me to the online help

Re: difference of 2 expressions

Frank_Hartmann — Thu, 28 Jul 2016 09:40:07 GMT

here you go 🙂

Re: difference of 2 expressions

sunny_talwar — Thu, 28 Jul 2016 09:43:08 GMT

Got it, thanks

I think what threw me off was Year = Year was used instead of Year = p(Year).