how to ignore a unique field with set analisys?

[#1]

I need to create a set analisys, but i need for example ignore just a one field...

Sum( {$<YEAR={$(=YEAR-1),MONTH={ALL}}>} SALES)

That example .....i need to ignore a selected month......if a user select some month....i want to ignore and take every month!!!!!

tks a lot!@!!

[jonathandienst]

Something like this perhaps:

Sum( {<YEAR={"$(=Max(Total YEAR)-1)"}, MONTH=>} SALES)

Jonathan

[#3]

Why MONTH=> ?????

Dont work and i didnt understand!!!!

[jonathandienst]

Enrico

MONTH= (ie the field name, followed by the = sign with nothing after it) makes the expression ignore any selections on that field.

I am not sure of your table structure, or exactly what value you are trying to get. Thats why I said "something like".

My suggestion should work if you have a table with fields YEAR, MONTH and SALES.

YEAR={"$(=Max(Total YEAR)-1)"} - this should match records where YEAR is equal the largest value for YEAR less 1. ie If 2010 is the max value of YEAR, it will match records with YEAR 2009. In this case, the expression would sum SALES for all records with YEAR 2009, and would ignore selections of MONTH.

If you need more help, I suggest that you post your model here so that I or someone else can look at it and make some further suggestions.

Jonathan

[#5]

Tks for your explanation Jonathan....

...i understood.....but i use a month just for example.....i just want something like when we use a Identifier 1, but is different....because i want just ignore one field and not all fields....

....i hope hava a simple syntax with this..

tks for your attention!!!!

[johnw · Accepted solution]

The simple syntax is what has been described:

{<MyField=>}

An equals sign with nothing after it tells QlikView to ignore that selection for that expression.

[#7]

Tks John...

But i try use toether another field......and still not working...

Sum({$<YEAR={$(=Only(YEAR)-1)},MONTH=>} SALES)

[#8]

Hi Erico,

I think it is because you have an error on the expression in the year part, try with something like this:

SUM({$<YEAR = {$(#=Only(Year)-1)}, MONTH = >} Sales )

Tell us if it works like this plz.

Regards

[#9]

The year part i just copyied from Qliktech Example......

However i try your expression, works like mine, but still filtering when i select a month!!!!

tks again!!!!

[#10]

Do you have your month filter with Name and number?, because if you have even the number you have to put it on the formula too

NumberMonth = , NameMonth=

Regards