Solved: Re: Data Islands and Set Analysis - Qlik Community

SRG · ‎2019-06-16

Hi,

In my data model I have a date filed. I am using date Island to and compare against the date in my data model. Using 'IF' I am getting desired results. I need to compare two more conditions in my expressions to calculate sums. Use if is slowing down all the calculations. I am trying to see if I can use set expression with date Island.

The expression I am currently using is

sum(if([Date]=IslandDate,Type ='Dispute',ChkFlag='Yes',1)) . Can I obtain the same with set expressions.

Any help would be highly appreciated.

Brett_Bleess · ‎2019-07-17

Duplicate post, see https://community.qlik.com/t5/New-to-QlikView/Data-Islands-and-Set-Analysis/m-p/1592330#M376521 for further discussion.

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

saar_lorena · ‎2019-06-17

Hi!

Do you have an example to share here with us?

😃

Brett_Bleess · ‎2019-07-17

Duplicate post, see https://community.qlik.com/t5/New-to-QlikView/Data-Islands-and-Set-Analysis/m-p/1592330#M376521 for further discussion.

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.