topic Re: Some help with set in QlikView

Some help with set

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

I have this expression. sum({<Month=, Year = {"$(#=max(Year))"}, MonthNr= {1,2,3,4,5,6} >} Sale)

Now I want to exclude some transactions that can be backdated. The transaction have a UTYP = 201 and INSDATE larger then Max(Year) Month 07 and Day 03.

How can I include that exclude-expression in the set?

Re: Some help with set

Anil_Babu_Samineni — Thu, 06 Jul 2017 16:01:35 GMT

You can exclude like -= in your set analysis

I would ask you to create this statement in script, I assume INSDATE has Year Values if not you may create Year(INSDATE) as Year and then use Year direct rather INSDATE for condition

If(UTYP <> '201', If( INSDATE > Max(TOTAL Year), If( Month <> '07' , If(Day <> '03', 'Exclude', 'Include') as FieldName

And then some thing like this for set expression

sum({<Month=, Year = {"$(#=max(Year))"}, MonthNr= {1,2,3,4,5,6}, FieldName -= {'Exclude'} >} Sale)

Re: Some help with set

sunny_talwar — Thu, 06 Jul 2017 16:39:32 GMT

You can also use e()

P() & E() and where do you use them?