Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What's HIC's blog?
ahhh and what is a YTD?
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:
Ahhh I thought that could be him, but i was not sure (until now).
Well, YTD mystery solved !
Thanks!