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

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

Vamsy1991 — Fri, 15 Nov 2024 23:50:43 GMT

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 — Thu, 08 Oct 2020 16:58:16 GMT

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.