Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
JMAROUF
Creator
Creator

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)
  • Other

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

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! 

JMAROUF
Creator
Creator
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

View solution in original post