Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor III

How to modify my expression =(Sum({<rEVENUE={rEVENUE}>}Amount)) ?

Hi All

(A)Below script generate field name = rEVENUE :-

If([Reporting Code]>=1 and [Reporting Code]<=15,'rEVENUE') as [rEVENUE],

it working fine for below expression :-

When i Click on field name = rEVENUE , it will select GL_CODE i want for Revenue.

=(Sum({<rEVENUE={rEVENUE}>}Amount))


(B) Below script generate field name = GL_SELECT :-

ApplyMap('MapGL',@1:16T,'9 OTHERS') as [GL_SELECT],

9 OTHERS
1 Revenue
2 COST
3 OTHER INCOME

When i Click on label name = 1 Revenue , it will select GL_CODE i want for Revenue.

But the expression is not working fine below :-

=(Sum({<[1 Revenue]=[1 Revenue]>}Amount))

May i know where go wrong ?

Paul Yeo

 

1 Solution

Accepted Solutions
Partner
Partner

Re: How to modify my expression =(Sum({<rEVENUE={rEVENUE}>}Amount)) ?

Try these expressions:

=(Sum({<rEVENUE={'rEVENUE'}>}Amount))

 

=(Sum({<[GL_SELECT]={'1 Revenue'}>}Amount))

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

3 Replies
paulyeo11
Valued Contributor III

Re: How to modify my expression =(Sum({<rEVENUE={rEVENUE}>}Amount)) ?

Hi All

Should be some thing like below :-

=(Sum({<if(GL_SELECT=[1 Revenue])=if(GL_SELECT=[1 Revenue])>}Amount))

But it return null value.

Paul Yeo

Partner
Partner

Re: How to modify my expression =(Sum({<rEVENUE={rEVENUE}>}Amount)) ?

Try these expressions:

=(Sum({<rEVENUE={'rEVENUE'}>}Amount))

 

=(Sum({<[GL_SELECT]={'1 Revenue'}>}Amount))

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

paulyeo11
Valued Contributor III

Re: How to modify my expression =(Sum({<rEVENUE={rEVENUE}>}Amount)) ?

Hi Vegar

Wow , your expression working fine, Thank you very much.

Paul Yeo