Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Highlighted
everest226
Not applicable

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
Not applicable

Re: expression

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.