Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!@!!
Érico,
Do you have MONTH in a Dimension in your graph?
No, i have a dynamic table .....just a select field (Month)
Could you post your qvw?
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]