Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I am using a straight table to for an HTML Report. This HTML report is embedded into the email body.
But the received email is not keeping the table format as it is in qlikview !
What could be wrong ?
Background : Straight Table in QlikView has one dimension as one expression like this.
=Num(Avg([Working Days]),'0')
Problem :When Report is being published then the table in email contains up to 10 decimal point like this.
Product Category | Working Days |
Consultancy | 3.212457813 |
Examinations | 8.285714286 |
NOTE : Keep Source format is ticked in NPrinting HTML Report and in Qlikview Numebr format is kept as Expression Default
Hi Lokesh,
Its the problem with num function try like this
=round(Num(Avg([Working Days]),'0'))
Hi Lokesh,
Its the problem with num function try like this
=round(Num(Avg([Working Days]),'0'))
Thanks Avinash