topic Re: Help with Qlikview Formula in QlikView

Help with Qlikview Formula

Fri, 11 Jan 2013 09:31:23 GMT

Need a quick help. I have a formula showing Quantity on Purchases Order for component code only:

Sum(Total<[Component Code]> If([Assembly Type] = 'ITEM', [Loc Qty on PO] * [Component Qty] )) * Weighting

This is for all branches. However, I want to show the quantity on Purchase Order for one of our branches Johannesburg ,only , and this is my formula:

if(Branch= 'Johannesburg', (Sum(Total<[Component Code]> If([Assembly Type] = 'ITEM', [Loc Qty on PO] * [Component Qty] )) * Weighting))

However this does not work and the result is blank.

Please can you help.

kind regards

Nayan

Re: Help with Qlikview Formula

Fri, 11 Jan 2013 09:40:19 GMT

Hi,

May be you can try this:

//For all branches

=sum({<[Assembly Type] = {'ITEM'}>}([Loc Qty on PO] * [Component Qty])*Weighting)

//For Johannesburg

=sum({<[Assembly Type] = {'ITEM'},Branch= {'Johannesburg'}>}([Loc Qty on PO] * [Component Qty])*Weighting)

Hope that helps.

Regards,

-Khaled.

Re: Help with Qlikview Formula

Fri, 11 Jan 2013 09:59:21 GMT

Hi Khaled

Thanks . Will try it and let you know.

kind regards

Nayan

Re: Help with Qlikview Formula

Fri, 11 Jan 2013 10:08:03 GMT

Hi Khaled

Therer is an error in the formula. The error that comes up is :

"Bad filed names(s): Weighting"

kind regards

Nayan

Re: Help with Qlikview Formula

Fri, 11 Jan 2013 10:47:39 GMT

Hi Khaled

I moved the bracket after weighting and placed it before and it worked.

regards

Nayan

Re: Help with Qlikview Formula

Fri, 11 Jan 2013 11:35:33 GMT

Hi Nayan,

Glad it's fixed. I would suggest you to use Set Analysis to write similar conditions in the future scenarios. It's a very powerful feature and you will get accurate results for your logical calculations with ease.

Regards,

-Khaled.