Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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

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

 

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Creator
Creator

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.

 

View solution in original post

1 Reply
Highlighted
Creator
Creator

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.

 

View solution in original post