NPrinting Excel Report formula - purpose of '_'

[AjjuSid]

Hi All,

I am trying to Break Down and Understand a NPrinting report (Excel Format) which was not build by me. 

I am stuck at this particular formula below- in the if statement it has '_' (underscore) before .6666 & .895.

I tried looking online if Qlik NPrinting has '_' Operator .

formula is enclosed in <> brackets

Strangely it's not giving any syntax error instead evaluates the formula and gives me result as 1%. 

@Lech_Miszkiewicz   @Stephen_Jasionowski  @Anil_Babu_Samineni 

Can the experts please help me with this?

Thanks in Advance.

if(Match([Product Code],'0001','0002','0003','0004','0005','0006'),0.01,
          (if(Sum(PaidAmount+PaidReserves)/Sum(Premium)_.6666,0.01,
                     if(Sum(PaidAmount+PaidReserves)/Sum(Premium)_.895,0.2,0.10))))

[Lech_Miszkiewicz]

It is nto a formula in NPrinting i think.

Instead it seems like column which you are trying to bring in did not have label and its expression was brought in as NPrinting measure tag

That is why you have those "_" characters it think.

cheers

[Ruggero_Piccoli · Accepted solution]

Hi,

Qlik NPrinting has not a native formulas system.

If you are working on an Excel template and this formula is in a cell it is an Excel formula.

If it is in the Formulas node on the left side treeview it is a QlikView/Qlik Sense formula. In this case the syntax is the Qlik one and the formula is sent as is to the related connection, is evaluated and the result returned and placed in the report. 

So you have to check the formula based on the type it is. 

Best Regards,

Ruggero

[AjjuSid]

Thank you for your replies!