With INPUTFIELD Unable to show Expression Total

Fri, 18 Jul 2014 07:32:12 GMT

Hello Frnds,

We have couple of issues while using ‘INPUTFIELD’. These input fields are being used to capture simulation values for certain parameters. Input field values are used in computation of below straight table. While doing so, we have the following challenges:

a) 1)Unable to use the column name in the expression.

b) 2) How to compute weighted average in the total row.

c) 3)Unable to show the expression total.

Explanation:

Parameters table is used to capture Count of rejected products and the % increase / decrease over the average cost of product type.

Simulation straight table column “Product Cost” is the average cost of each product type. We need to compute the weighted average cost of all product types and display the same in total row.

Rejected count and associated % increase / decrease in cost over the average product cost computations are in the subsequent fields.

Net product count = Product count – Rejected count

Net product amount = Product amount – Rejected amount

Net product cost = Net product amount / Net product count

Attached is the example qvw.

Re: With INPUTFIELD Unable to show Expression Total

kaushiknsolanki — Fri, 18 Jul 2014 07:35:19 GMT

HI,

Just change your expression to below.

Sum([Prod Amt]/[Prod Count])

The expression should be used in aggregation function to get the total.

Regards,

Kaushik Solanki

Re: With INPUTFIELD Unable to show Expression Total

SergeyMak — Fri, 18 Jul 2014 07:43:18 GMT

Hi,

Did you try to use simple variables instead of Inputfields?

Regards,

Sergey

topic Re: With INPUTFIELD Unable to show Expression Total in QlikView

With INPUTFIELD Unable to show Expression Total

Re: With INPUTFIELD Unable to show Expression Total

Re: With INPUTFIELD Unable to show Expression Total