Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have a requirement as below:
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>'
)
please help.,
Thank you.