topic Re: Straight Table, Expression construction in QlikView

Straight Table, Expression construction

Anonymous — Sat, 28 Jan 2012 18:33:54 GMT

Hi,

I have what looks to be a simple problem with a expression in a straight table.

I might just miss the obvious – but please help.

Small example:

MyData:

Load * Inline [

MatCode, Amount, Quantity

"A", 10, 80,

"B", 20, 20,

"B", 5, 10

];

I create a Straight table:

Dimension = MatCode

Expression Total Amount = sum(Amount)

Expression Total Quantity = sum(Quantity)

Expression Avg Price = sum(Amount) / sum(Quantity)

Now I want an expression that sum(Quantity), but only for the records where price >= (Avg Price – 1%)

In this example I would expect the new expression to give this result: A = 80 and B = 20

Any ideas?

Thanks in advance

Nils

Sat, 28 Jan 2012 21:40:37 GMT

If I understand the problem correctly, see attached application example and let me know if this is what you are looking for.

Result table in the application show sum of quantity when condition price >= (Avg Price – 1%) is true.

Regards,

Manoj

Anonymous — Sat, 28 Jan 2012 22:11:18 GMT

Hi,

Thanks for you input.

This gives the correct answer, but I am looking for a more flexible solution - the full calculation made inside the expression.

The the calculation is made inside the expression, it will be possible to make selections on other fields on the records.

Best regards

Nils

Sat, 28 Jan 2012 22:23:59 GMT

Here you go ...

Anonymous — Sat, 28 Jan 2012 22:46:59 GMT

Thank you 🙂 Just what I was looking for