Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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
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
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