topic Re: Set Analysis Help in QlikView

Set Analysis Help

abhaysingh — Wed, 02 Sep 2015 11:41:07 GMT

Hi All,

Need Below Logic in set analysis..

(if(Duty_Free_Flag = 'Y',(sum(Land_Cost +ActLand_Cost)*sum(Quantity)), if(Duty_Free_Flag = 'N',(sum((Land_Cost +[Stock Landed Cost])*(Quantity))))) + (sum(Quantity * Land_Cost)+sum(Tot_Duty))) - sum(Tot_Duty)

Kindly suggest

Re: Set Analysis Help

Anonymous — Wed, 02 Sep 2015 11:54:49 GMT

hi abhay,

may be try :

if(Duty_Free_Flag = 'Y',((sum(Land_Cost) + sum(ActLand_Cost))*sum(Quantity)) + ((sum(Quantity) * sum(Land_Cost)+ sum(Tot_Duty)) - sum(Tot_Duty)),

if(Duty_Free_Flag = 'N',((sum(Land_Cost) + sum([Stock Landed Cost]))* sum(Quantity)) + ((sum(Quantity) * sum(Land_Cost)+ sum(Tot_Duty)) - sum(Tot_Duty))))

Re: Set Analysis Help

jonathandienst — Wed, 02 Sep 2015 12:00:39 GMT

This is a logic branch. Set analysis is for filtering, not for branching the expression. You have no filters in the expression.

Set analysis is not 42*.

*See Hitchhikers Guide to the Galaxy

Re: Set Analysis Help

abhaysingh — Wed, 02 Sep 2015 12:03:23 GMT

Actually I need total Amount After this Expression, but when I am using it not getting Final Amount as total.

Re: Set Analysis Help

jonathandienst — Wed, 02 Sep 2015 12:08:52 GMT

I am not saying your expression is correct, I am saying that set analysis is not the answer.

Have you checked your parentheses?

Post your qvw or a representative sample with the value you expect from the expression for more detailed help.

Re: Set Analysis Help

Kushal_Chawda — Wed, 02 Sep 2015 12:17:58 GMT

try pick & match instead of If

=(pick(match(Duty_Free_Flag,'Y','N'),

sum(Land_Cost +ActLand_Cost)*sum(Quantity),

sum((Land_Cost +[Stock Landed Cost])*(Quantity)))

+ (sum(Quantity * Land_Cost)+sum(Tot_Duty))) - sum(Tot_Duty)

Re: Set Analysis Help

abhaysingh — Wed, 02 Sep 2015 12:27:35 GMT

Thanks For revert but I am not getting Total for the same, I don't want to select any field to get result..