topic Re: set analysis syntax in QlikView

set analysis syntax

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

Hi,

I use this set analysis to filter the data that belong to a week:

sum({$< tt_settimana ={"$(=vSettimana)"}>} tt_hh_inserite)

vSettimana is a variable so defined:

LET vSettimana = year(today()) & '-' & week(today()-7)

And is works correctly.

Now I need to filter the data >= vSettimana. I try some different syntax:

sum({$< tt_settimana ={"$(>=vSettimana)"}>} tt_hh_inserite)

sum({$< tt_settimana ={">=$(=vSettimana)"}>} tt_hh_inserite)

but these don't give me any result.

Can anyone help me, please?

Re: set analysis syntax

lironbaram — Thu, 12 Dec 2019 11:48:36 GMT

this one should work

sum({$< tt_settimana ={">=$(=$(vSettimana))"}>} tt_hh_inserite)

Re: set analysis syntax

PrashantSangle — Thu, 12 Dec 2019 11:55:48 GMT

Some of the possible reason for not working is
1: result which you are getting for variable is in string. not in number because of '-' in it and you can not give range for text. so in that case convert it into number by removing '-' from both.

Regards,

Re: set analysis syntax

lfetensini — Thu, 12 Dec 2019 12:00:49 GMT

The expression cant be walk in up or down because its a "text" with '-' and not a number to be >=. Think about letter D, can E be >=D? Absolutely not.

Change your variable:

OLD (2019-30):
LET vSettimana = year(today()) & '-' & week(today()-7)

NEW (201930):
LET vSettimana = Year(Today()) & Week(Today()-7)

In Set, use:

Sum({<tt_settimana={">=$(=vSettimana)"}>} tt_hh_inserite)

You can ADD a Field in your calendar to walk (Week + 1) ou (Week - 1) between years if necessary. Try it:

AutoNumber(Num(Year(DATAFIELD)*54) + Num(Week(DATAFIELD))) as WeekID

Then use WeekID to do >= or <= and etc.

Re: set analysis syntax

Tmassimo — Thu, 12 Dec 2019 13:04:23 GMT

Thank you,

I removed '-' and now the set analysis works correctly.

Re: set analysis syntax

lfetensini — Thu, 12 Dec 2019 15:51:09 GMT

"Like" it the answers that are helpful to you and flag as solved the one that helped you solve.

Cheers.