Space in aggregation function

jeevays7 — Mon, 09 Jan 2017 12:08:13 GMT

Hi frds,

I have a result table like this.

Table1:

Name Gross Net

A 50 40

B 50 30

C 40 20

The expression of Net column is:

Num(sum(aggr(Sum({$<CAPITAL_FLOW_TRANSACTION_DATE= {"$(vDateMax)"}>} EXPOSURE ),SEC_ID,EXT_ID))

Sum(Total {$<CAPITAL_FLOW_TRANSACTION_DATE= {"$(vDateMax)"}, $(=vNullify)>} CLOSING_CAPITAL )

,'$#,##0').

If i make a space in the above expression at Before SEC_ID in aggregation like below,

Num(sum(aggr(Sum({$<CAPITAL_FLOW_TRANSACTION_DATE= {"$(vDateMax)"}>} EXPOSURE ), SEC_ID,EXT_ID))

Sum(Total {$<CAPITAL_FLOW_TRANSACTION_DATE= {"$(vDateMax)"}, $(=vNullify)>} CLOSING_CAPITAL )

,'$#,##0').

The result is changed like this.

Result with Space in aggregation:

Name Gross Net

A 30 30

B 50 30

C 40 20

- 20 10

why?

and the above table with space in aggregation, if i check suppress null value, it is displayed correctly as Table1. but when we publish the document in browser the result is not correct. it looks like below,

Result with Space in aggregation and suppress null and published in browser:

Name Gross Net

A 30 30

B 50 30

C 40 20

why?

Re: Space in aggregation function

sunny_talwar — Mon, 09 Jan 2017 12:12:03 GMT

Would you be able to share your app to show the issue (or a sample where this issue is present)?

Re: Space in aggregation function

jeevays7 — Mon, 09 Jan 2017 12:17:30 GMT

Hi sunny,

Thanks for your reply. that is a big app sunny. cant able to upload

Re: Space in aggregation function

sunny_talwar — Mon, 09 Jan 2017 12:20:50 GMT

See if this helps:

Preparing examples for Upload - Reduction and Data Scrambling

topic Re: Space in aggregation function in QlikView

Space in aggregation function

Re: Space in aggregation function

Re: Space in aggregation function

Re: Space in aggregation function