Translate Crystal report code to Qlikview code

[#1]

Hello,

Got a Crystal report and want to use Qlikview instead of it. Below the code. Unfortunately I cannot paste it directly [:(]

Does anybode know how to translate it into Qlikview language?

If {table1.pr_type} = 'Days'
Then {table2.Production} - {table2.nonTA}
Else (If {table1.pr_type} = 'Halfdays' Then {table2.Production} - {table2.Correction} Else {table2.Production}/ 60)

Richard

[vupen]

I understand the piece of code you want to translate is inside an expression. You can use the syntax: If(condition,expression,else_expression). When translated, your code looks as below:

If(table1.pr_type = 'Days',table2.Production - table2.nonTA,If(table1.pr_type = 'Halfdays',table2.Production - table2.Correction,table2.Production/ 60))