Discussion board where members can get started with QlikView.
Please suggest me to create the expression for sum(if(R_View='Gross',A,B,A)) in Qlikview
when i opened the application by default i need to show the valus for A(Sales)
Please help me
Hi @Vamsy1991 ,
you can use the below expression
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.
View solution in original post