topic Re: Set Analysis Doubt in QlikView

Set Analysis Doubt

bruno_m_santos — Fri, 31 May 2013 12:24:32 GMT

Hi,

I'm trying to make a Setanalysis expression but until now without success.

I want exclude Brands where (365-Max( $(vSetRolling12) Date) + Min( $(vSetRolling12) Date)) <$(vL4LNrDays)

Could you give me an hand

Thanks

Bruno

Sum({$<MonthID = {">=$(=Max(MonthID) - 11)<=$(=Max(MonthID))"},
CalendarType = {$(=vCalendarType)},
MonthOrder = ,
Date = {"<=$(=Max(Date))"},
Year = ,
FiscalYear = ,
Quarter = ,
Period = ,
Week = ,
[Period (#)] = ,
[Brand Code]= E({$<_Inactive_Brand={'1'},
Date = {">=$(=min( $(=$(vSetRolling12)) Date)) <=$(=max( $(=$(vSetRolling12)) Date)))"}> }

>}),
Month = >} [#Sales EUR])

//(365-Max( $(vSetRolling12) Date) + Min( $(vSetRolling12) Date)) <$(vL4LNrDays)

Re: Set Analysis Doubt

Fri, 31 May 2013 13:27:14 GMT

I don't know exactly what you're looking for... Date function needs parenthesis.

However, start by combining (365-Max( $(vSetRolling12) Date) + Min( $(vSetRolling12) Date)) in 1 variable so in your set analysis it'll be easier to evaluate.

Re: Set Analysis Doubt

Gysbert_Wassenaar — Sat, 01 Jun 2013 16:22:27 GMT

See here

Re: Set Analysis Doubt

bruno_m_santos — Mon, 03 Jun 2013 11:50:40 GMT

Hi Gysbert

I’m uploading my app to demonstrate my issue.

You ‘ll find a last column “Like For Like”. In this column I´m filtering the inactive Brands, but I need filter Brands that in the last Rolling12 have 365-Max( $(vSetRolling12) Date) + Min( $(vSetRolling12) Date)) <5

Thanks in Advance

Bruno

Re: Set Analysis Doubt

Gysbert_Wassenaar — Mon, 03 Jun 2013 13:32:12 GMT

Maybe this:

sum({<

MonthID = {">=$(=Max(MonthID) - 11)<=$(=Max(MonthID))"},

CalendarType = {$(=vCalendarType)},

MonthOrder = ,

Date = {"<=$(=Max(Date))"},

Year = ,

FiscalYear = ,

Quarter = ,

Week = ,

[Period (#)] = ,

Month = ,

[Brand Code]={'=(365-Max( $(vSetRolling12) Date) + Min( $(vSetRolling12) Date)) <$(vL4LNrDays) and Sum({$(vRolling12)} _Inactive_Brand)<1'}

[#Turnover EUR])

Re: Set Analysis Doubt

bruno_m_santos — Mon, 03 Jun 2013 14:16:04 GMT

FANTASTIC.

Many Thanks Gysbert.

I was completely in the wrong direction. I thought this was only possible with P () and E (). I have a question. Why use single quote instead of double Quotes.

Thnks

Bruno