Help with Set Analysis

[DSTaylor]

Hi,

I'm relatively new to Qlik and heard about Set Analysis. 

It sounds like what I need as I have 2 parts to a calculation. The first part I do want to change with selections, the second part I don't. I believe it is in this second part where Set Analysis can come into play.

Here is my IF( statement for the 2nd part.

=sum(
if(ContractDate>=today()-365,
if(Hrs>0,
ContractedHrs)))

Could someone please change this into a Set Analysis for me?

Thanks!

[ksindhukannan]

Sum({<ContractDate={">=Today()-365"}, Hrs={">0"}>} ContractedHrs)

[Brett_Bleess · Accepted solution]

See duplicate posts: https://community.qlik.com/t5/New-to-QlikView/Please-can-someone-help-with-a-quick-Set-Analysis/m-p/...

https://community.qlik.com/t5/QlikView-Scripting/Help-with-simple-Set-Analysis/m-p/1673037#M98209

Please do not create new posts on the same topic, you should be utilizing your initial post and updating that post, duplicates will frustrate those trying to assist you, so again, be sure to update your initial post and keep that going if you still require assistance.

Regards,
Brett