Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
everest226
Creator III
Creator III

expression

If( [Type] = 'A' , -1 * [Volume]  * NUM([ Rate]) )

 

now i want to add contract year field  in the expression 

so basically if  type is A and contract year is following calculate the year value.

so i have a table with 

2016   12.4

2017    52.2

2018   12.12

Labels (1)
1 Reply
vishsaggi
Champion III
Champion III

Can you explain a little more please what your expected output should be. Can you share some more data? You can give your Contract Year in your if like If(Type = 'A' and Year = '2016' , yourexpr) but i believe this is not what you are looking for, so need more information.