topic Re: Expression help in QlikView

Expression help

danielnevitt — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have the following expression and I would appreciate some help with adding a DISTINCT trade_num to the expression:

sum(total <udf_code> fabs(pos_lots))

Thanks,

Daniel

Re: Expression help

kaushiknsolanki — Thu, 17 Nov 2016 12:01:52 GMT

Hi,

Can you tell us what this expression does and how it is related to Trade_num

Regards,

Kaushik Solanki

Re: Expression help

danielnevitt — Thu, 17 Nov 2016 12:03:53 GMT

Hi,

The expression absolute sums the total position lots by udf code.

Trade numbers make up the total position lots and I only want to sum where trade_num is distinct.

Thanks,

Daniel

Re: Expression help

sunny_talwar — Thu, 17 Nov 2016 12:03:53 GMT

Also, if you can provide some information about the chart where it is getting used and what all are the dimensions?

Re: Expression help

danielnevitt — Thu, 17 Nov 2016 12:06:31 GMT

Hi,

It a column in a straight table. I am trying to product the absolute pos_lots where trade_num is distinct when there are multiple rows on a table (for example different trader IDs).

Regards,

Daniel

Re: Expression help

sunny_talwar — Thu, 17 Nov 2016 12:09:05 GMT

So essentially sum the expression only when there is a single trade_num. If there are more than one instance of the same trade_num you don't want to sum them in your expression?

Re: Expression help

danielnevitt — Thu, 17 Nov 2016 12:10:22 GMT

If there is more than one of the same trade_num, I just want to sum it once.

Hope that makes sense.

Thanks

Re: Expression help

sunny_talwar — Thu, 17 Nov 2016 12:13:33 GMT

May be this:

Sum(TOTAL <udf_code> Aggr(Sum(DISTINCT fabs(pos_lots)), trade_num))

Re: Expression help

sunny_talwar — Thu, 17 Nov 2016 12:15:07 GMT

and all of these should work also (I think)

Sum(TOTAL <udf_code> Aggr(Avg(fabs(pos_lots)), trade_num))

Sum(TOTAL <udf_code> Aggr(Only(fabs(pos_lots)), trade_num))

I am assuming that each trade_num will have one and only one pos_lots value. If this is not true, then we would need to know which value of pos_lots need to be picked for each trade_num

Re: Expression help

danielnevitt — Fri, 18 Nov 2016 10:37:11 GMT

Thanks for your help