Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
JMAROUF
Creator II
Creator II

the use of "*/" in set analysis

Can anyone tell me what is the meaning of  "*/"   in this set analysis please {<date={"*/$(=Year(Max(date)-1))"}   ?

Thanks in advance.

Labels (1)
1 Solution

Accepted Solutions
micheledenardi
Specialist II
Specialist II

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

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

3 Replies
micheledenardi
Specialist II
Specialist II

Here you can find the information you need:

Set Analysis in QlikView – simplified! 

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
JMAROUF
Creator II
Creator II
Author

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.

micheledenardi
Specialist II
Specialist II

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

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.