Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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

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!