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

Announcements
Check out our latest virtual session where BARC Fellow, Doug Laney, highlighted the opportunities data monetization can offer enterprises. 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]