topic Re: how to reuse a result from column expression in QlikView

how to reuse a result from column expression

weezerian — Mon, 29 Oct 2018 04:11:56 GMT

hello, i need help..

i have a data like this,

LOAD * INLINE [

Code, amount, claim, goods

1, 10, 1, A

1, 10, 2, B

1, 5, 2, A

2, 5, 3, C

2, 4, 2, D

];

i want to make a table like the image below. which is

- "total amount = sum(amount)"

- "total claim = sum(claim)"

- "goods with maximum claim" => it's solved

- "max claim" = number of claim => it's solved

- "amount of max goods" = i don't know how to make the exact amount like the image below.

thannila — Mon, 29 Oct 2018 06:07:23 GMT

Hi,

How you calculate max claims here?

Because for code number 2 ->max claims value is 10

can you explain in detail?

weezerian — Mon, 29 Oct 2018 06:31:59 GMT

sorry, the name of column amount of max goods & max claims is confused,,it should be like this...

tresB — Mon, 29 Oct 2018 07:27:29 GMT

Should not max goods amount for C be 5 instead of 10?

weezerian — Mon, 29 Oct 2018 07:41:11 GMT

yes, it should be 5, sorry for my mistake

tresB — Mon, 29 Oct 2018 07:48:23 GMT

Check the attached app. Few of your expressions are also simplified.

weezerian — Mon, 29 Oct 2018 09:16:18 GMT

Awesome, you're the best