Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
DSTaylor
Contributor II
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
Brett_Bleess
Employee
Employee

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

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.

View solution in original post

2 Replies
ksindhukannan
Partner - Contributor
Partner - Contributor

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

Brett_Bleess
Employee
Employee

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

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.