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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
eduardo_dimperio
Specialist II
Specialist II

Understanding Set Analysis

Hi everyone,

Someone have a good material to help me to understand Set Analysis?

I was looking this forun and found some codes that i dont understant like:

Count(DISTINCT {$<CommercialSite = {"=$(variable1) > 0 and $(variable2)>0"}>} [CommercialSite])


or


Sum({$<[Fiscal Year]={"$(=Only([Fiscal Year]))"}, [Fiscal Period]>} [Sales])



When i use {}, <>,[], $?

Why put some equation between " " ?


Thank you



12 Replies
eduardo_dimperio
Specialist II
Specialist II
Author

What's HIC's blog?

ahhh and what is a YTD?

sunny_talwar
MVP
MVP

What is YTD? Year To Date.

HIC is a person and he works with Qlik and produces some exceptional blogs. You can check his content here:

hic

eduardo_dimperio
Specialist II
Specialist II
Author

Ahhh I thought that could be him, but i was not sure (until now).

Well, YTD mystery solved !


Thanks!