Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anyone tell me what is the meaning of "*/" in this set analysis please {<date={"*/$(=Year(Max(date)-1))"} ?
Thanks in advance.
Not sure they can be used together since * means Intersection and / means Symmetric Difference.
{<date={"*$(=Year(Max(date)-1))"}>} this returns all "date" where the year is equal to the year of Max(date)-1 according to current selections.
{<date={"/$(=Year(Max(date)-1))"}>} this returns all "date" where the year is not equal to the year of Max(date)-1 and not equal to current selections
Here you can find the information you need:
Set Analysis in QlikView – simplified!
Thank you @micheledenardi for the reply, i have read the article, it's interesting, however i can't understand the meaning of this formula:
Max(TOTAL {<date={"*/$(=Year(Max(date)-1))"}>} Aggr(If(date=Max(TOTAL <id_invested> date,2), Max(position)),id_invested,date))
can you help by interpreting the meaning of {<date={"*/$(=Year(Max(date)-1))"}>} here please?
Thank you.
Not sure they can be used together since * means Intersection and / means Symmetric Difference.
{<date={"*$(=Year(Max(date)-1))"}>} this returns all "date" where the year is equal to the year of Max(date)-1 according to current selections.
{<date={"/$(=Year(Max(date)-1))"}>} this returns all "date" where the year is not equal to the year of Max(date)-1 and not equal to current selections