Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
abhaysingh
Specialist II
Specialist II

Logic Help

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

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Use below expression for Rate

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

View solution in original post

6 Replies
ramoncova06
Specialist III
Specialist III

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

MK_QSL
MVP
MVP

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.

abhaysingh
Specialist II
Specialist II
Author

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

MK_QSL
MVP
MVP

Use below expression for Rate

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

View solution in original post

abhaysingh
Specialist II
Specialist II
Author

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

MK_QSL
MVP
MVP

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