How to create the expression for sum(if(R_View='Gross',A,B,A)) in Qlikview

[Vamsy1991]

Hi,

Please suggest me to create the expression for sum(if(R_View='Gross',A,B,A)) in Qlikview

R_View=Gross,Net

A=Sales

B=Profit

when i opened the application by default i need to show the valus for A(Sales)

Please help me

[ramchalla · Accepted solution]

Hi @Vamsy1991 ,

you can use the below expression 

sum(if(R_View='Gross',A,B)).

you can apply the on open trigger to set the R_View value to 'Gross'.

go to Settings -> Document Properties -> Triggers -> On Open -> Add action -> Add -> Selection -> Select in Field ->

in the Field, you can specify as R_View and values as "Gross" as per the attached screenshot.