Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to ignore a unique field with set analisys?

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!@!!

13 Replies
Clever_Anjos
Employee
Employee

Érico,

Do you have MONTH in a Dimension in your graph?

Not applicable
Author

No, i have a dynamic table .....just a select field (Month)

Clever_Anjos
Employee
Employee

Could you post your qvw?

Not applicable
Author

Clever,

So sorry.....how i said....i use a set analisys example from QlikTech....just to understand and learn more about set analisys.......and the object was done and i just added that function....

Actually the object not change the value, just re-order the table......i´m so shame about is....lololol

I use a expression equal this post: Sum({$<Ano={$(=Only(Ano)-1)},Mes=>} VentasNetas)[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/0045.Set_5F00_Analisys_5F00_GAG.zip:550:0]