topic Re: Data Islands and Set Analysis in QlikView

Data Islands and Set Analysis

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

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.

Re: Data Islands and Set Analysis

saar_lorena — Mon, 17 Jun 2019 19:49:51 GMT

Hi!

Do you have an example to share here with us?

😃

Re: Data Islands and Set Analysis

Brett_Bleess — Wed, 17 Jul 2019 13:19:08 GMT

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