i need to show up arrow and down arrow in N printing. i have written code in qliksense as below to copy the same formulas in nprinting. code is as below:
I am calculating month on month from current month and previous month. if my current month is greater than previous month then True statement else false statement, i have given in the code and it is working. But the same formula if i keep in nprinting in excel format with up arrow and down arrow , its giving me an error.
=if( sum({<Metric1={'123'}, Date = {'$(=$(vMTD))'}>}sales)> sum({<Metric1={'123'}, Date = {'$(=$(vPMTD))'}>}sales) , ' <strong style="color: rgb(0, 138, 0);">' & (sum({<Metric1={'123'}, Date = {'$(=$(vMTD))'}>}sales)- sum({<Metric1={'123'}, Date = {'$(=$(vPMTD))'}>}sales)) & '</strong><em style="color: rgb(0, 138, 0);"><i class="fa fa-arrow-up"> </i></em>' , ' <strong style="color: rgb(138, 0, 0);">' & (sum({<Metric1={'123'}, Date = {'$(=$(vMTD))'}>}sales)- sum({<Metric1={'123'}, Date = {'$(=$(vPMTD))'}>}sales)) & '</strong><em style="color: rgb(138, 0, 0);"><i class="fa fa-arrow-down"> </i></em>' )
