topic Re: Logic Help in QlikView

Logic Help

abhaysingh — Fri, 22 Jan 2016 15:32:14 GMT

Hi Guys,

Please find the Sample data

In the data u will see

Product Group | Material Code | Budget Qty | BUdget Rate | Exchange Rate

Against one work group as per data A6000 there are two material code, there Qty , Rate and Exchane Rate

Final Value is calculated by logic

sum([ZBudget_Budget Rate]* ExchangeRate*BudgetQty)

after calculating Budget Rate there is One rate comes, let say 22.91, but i want when i select material code against the product group that value 22.91 will not change.

Right now when i m doing it it is changing.

pls suggest

Re: Logic Help

ramoncova06 — Fri, 22 Jan 2016 15:42:31 GMT

not sure if I completely understood but I believe you want something like the attached document

Re: Logic Help

MK_QSL — Fri, 22 Jan 2016 15:42:38 GMT

Don't understood your question properly. but try below one..

sum({<[Material Code]=>}[ZBudget_Budget Rate]* ExchangeRate*BudgetQty)

Instead of 22.91 if you mention the exact amount as per your sample data, it will be easy to answer.

Re: Logic Help

abhaysingh — Fri, 22 Jan 2016 16:04:13 GMT

Hi Guys,

Pls find the attached sample, in this you will se against one material grp rate is 41.88 and for other 22.47,

and total rate is 22.91,

instead of rate 41.88 and for other 22.47, i want 22.91 for all material.

Hope i m clear with what i want

thanks

Re: Logic Help

MK_QSL — Fri, 22 Jan 2016 16:06:30 GMT

Use below expression for Rate

sum(TOTAL [ZBudget_Budget Rate]* ExchangeRate*BudgetQty)/sum(TOTAL BudgetQty)

Re: Logic Help

abhaysingh — Fri, 22 Jan 2016 17:30:45 GMT

Hi Manish,

One more thing want to ask, when i select any single material code, than Rate changes from 22.91 to their respective calculative value 41.88 or 22.47..

can we do it like , even we select particular material even than their Rate remain 22.91?

thanks

Re: Logic Help

MK_QSL — Fri, 22 Jan 2016 17:35:41 GMT

sum(TOTAL {<[ZBudget_Material Code]>}[ZBudget_Budget Rate]* ExchangeRate*BudgetQty)/sum(TOTAL {<[ZBudget_Material Code]>}BudgetQty)