topic Re: Distinct Expression Totals/Percentage in QlikView

Distinct Expression Totals/Percentage

danielnevitt — Tue, 25 Jun 2013 11:44:03 GMT

Hi,

When creating List Boxes with Sum Totals I use the following Expressions:

Sum(CONTRACT_QTY_MT)

Num((Sum(CONTRACT_QTY_MT)/Sum(total CONTRACT_QTY_MT)),'##0.0%)

However I would like to extend this to sum the CONTRACT_QTY_MT and also show as a % of the total CONTRACT_QTY_MT for distinct TRADE_NUM. I created the below:

Sum(aggr(sum(Distinct CONTRACT_QTY_MT), TRADE_NUM)) - this works fine

Num((Sum(aggr(sum(Distinct CONTRACT_QTY_MT), TRADE_NUM))/Sum(total(aggr(sum(Distinct CONTRACT_QTY_MT), TRADE_NUM)),'##0.0%') - this however does not display any data

I believe my issue may be the number of brackets?

Any help with the above would be much appreciated.

Regards,

Daniel

Re: Distinct Expression Totals/Percentage

narender123 — Tue, 25 Jun 2013 11:57:38 GMT

Hi,

Yes you have missed the brackets.

Try this.

Num(Sum(aggr(sum(Distinct CONTRACT_QTY_MT), TRADE_NUM))/Sum(total(aggr(sum(Distinct CONTRACT_QTY_MT), TRADE_NUM)),'##0.0%'))

Thanks.

Narender

Re: Distinct Expression Totals/Percentage

danielnevitt — Tue, 25 Jun 2013 12:06:52 GMT

Hi Narender/er.mohit,

Thank you for your replies.

Unfortunately the % values still do not appear.

Am I doing something wrong?

Regards,

Daniel

Re: Distinct Expression Totals/Percentage

narender123 — Tue, 25 Jun 2013 12:17:12 GMT

You may try this ..

Num(Sum(aggr(sum(Distinct CONTRACT_QTY_MT), TRADE_NUM))/

Sum(total CONTRACT_QTY_MT),'##0.0%')

Thanks.

Re: Distinct Expression Totals/Percentage

danielnevitt — Tue, 25 Jun 2013 12:26:34 GMT

Hi Narender,

Thanks again for your reply.

Unfortunately it still doesn't work though.

The first bracket after Num is showing as red. Not sure whether this is causing the problem?

Regards,

Daniel

Re: Distinct Expression Totals/Percentage

narender123 — Tue, 25 Jun 2013 12:32:55 GMT

Pls see the attachment file.

Re: Distinct Expression Totals/Percentage

danielnevitt — Tue, 25 Jun 2013 13:04:02 GMT

Thanks Narender.

I can see that the code works fine. However when inputting against my data, it still shows as blank.

I am using source data from an XML file. Do you think the XML file format might be causing the problem?

Regards,

Daniel