topic Re: Set analysis condition evaluation and its behavior. in QlikView

Set analysis condition evaluation and its behavior.

dsg_sheraz — Thu, 26 Jan 2017 07:57:39 GMT

Hi All,

I need your assistance to understand Set analysis behavior when there is nothing in the field on the selection of another field. Can you please open the attached dummy application. It explains the problem in detail.

Thank you

Re: Set analysis condition evaluation and its behavior.

sunny_talwar — Thu, 26 Jan 2017 14:14:59 GMT

Because you don't have a flag for Flower, it is causing this issue.... If you can fix this in the script, the problem should be resolved

Left Keep(Test)

LOAD * INLINE [

Product,IsVitamin

Flower,N

Meat,N

Yugurt,Y

];

Re: Set analysis condition evaluation and its behavior.

swuehl — Thu, 26 Jan 2017 14:53:24 GMT

I think what you experience is due the way Qlik handles the associations between tables and how the inference engine works using state vectors. Not saying that it's not a problem, it's definitely returning unexpected results.

If you don't know which values are missing and you don't want to create fake values, try

Left Keep(Test)

LOAD Product, if(IsVitamin='Y',Dual('Y',1),Dual('N',0)) as IsVitamin INLINE [

Product,IsVitamin

Meat,N

Yugurt,Y

];

Then:

=sum({<IsVitamin={'Y'}>}Qty *IsVitamin )

or just

=sum(Qty *IsVitamin )