Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Digital Support
Digital Support

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
Partner
Partner

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

Digital Support
Digital Support

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