topic Re: Set Analysis help in QlikView

Set Analysis help

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

Hi,

how to put below condition in set analysis

thanks in advance

if(sum({<Bucket = {'1 YR'}>}VMKUM) > sum(STOCK1), sum(STOCK1),sum({<Bucket = {'1 YR'}>}VMKUM))

Gysbert_Wassenaar — Wed, 20 Jul 2016 11:56:06 GMT

That if statement can't be transformed into a set analysis expression. It has two branches that each calculate a result.

avinashelite — Wed, 20 Jul 2016 12:00:20 GMT

Agree with gwassenaar‌ since it has branch statement we need to use If condition

sunny_talwar — Wed, 20 Jul 2016 12:03:56 GMT

How about this?

RangeMin(Sum(STOCK1), Sum({<Bucket = {'1 YR'}>}VMKUM))

abhaysingh — Wed, 20 Jul 2016 12:13:06 GMT

getting same output as if condition.. thanks

sunny_talwar — Wed, 20 Jul 2016 12:15:01 GMT

It does, its just another way to avoid the if statement in your case