topic Re: Issue in formatting in QlikView

Issue in formatting

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

Hi All,

I am having two list boxes called period 1 and Period 2. All I need to show the delta values between them. So when user selects two period I will calculate the delta values as per below expression

num((if(sum({<FLAG1 = {3},[YEAR MONTH]={'$(=GetFieldSelections(Period2))'}>}[GL Gross Value USD])

sum({<FLAG1 = {3},[YEAR MONTH]={'$(=GetFieldSelections(Period1))'}>}[GL Gross Value USD])

<0,

'($'&num(sum({<FLAG1 = {3},[YEAR MONTH]={'$(=GetFieldSelections(Period2))'}>}[GL Gross Value USD])

sum({<Flag1={3},[YEAR MONTH]={'$(=GetFieldSelections(Period1))'}>}[GL Gross Value USD]))*-1&')',

sum({<FLAG1 = {3},[YEAR MONTH]={'$(=GetFieldSelections(Period2))'}>}[GL Gross Value USD])

sum({<FLAG1 = {3},[YEAR MONTH]={'$(=GetFieldSelections(Period1))'}>}[GL Gross Value USD])))/10000000,'###.##')

However it showing "-" values in the expression. Kindly let me know what is the issue in formatting

Re: Issue in formatting

prma7799 — Tue, 24 Oct 2017 13:21:26 GMT

I think closing bracket is missing ...

Re: Issue in formatting

Anonymous — Tue, 24 Oct 2017 13:39:29 GMT

Hi,

Even I am not sure , Let me know if you able identify.

Re: Issue in formatting

avinashelite — Tue, 24 Oct 2017 13:40:25 GMT

re-check this

'($'&num(sum({<FLAG1 = {3},[YEAR MONTH]={'$(=GetFieldSelections(Period2))'}>}[GL Gross Value USD])

sum({<Flag1={3},[YEAR MONTH]={'$(=GetFieldSelections(Period1))'}>}[GL Gross Value USD]))*-1&')',