Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for
Did you mean:
Contributor II

## Help with Set Analysis

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!

1 Solution

Accepted Solutions
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
2 Replies
Partner - Contributor

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

Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Community Browser