topic Re: Help with Set Analysis in QlikView

Help with Set Analysis

DSTaylor — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Help with Set Analysis

ksindhukannan — Fri, 24 Jan 2020 10:02:17 GMT

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

Re: Help with Set Analysis

Brett_Bleess — Thu, 20 Feb 2020 13:47:48 GMT

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

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