Vizlib Home
Welcome
Login
Answered

Vizlib Table Export to excel - Hyphen

Vizlib Table Version: 3.8.0

Qlik: November 2019 Patch4

When export to excel hyphen is coming for null values.

When used null display '' or in load add if null '' these are working for string but not date or number values. 
Any idea on how can i make number, date values to come blank and NOT hyphen in excel export.

Appreciate any help.

Thank you.

  • Hi Padma, 


    As Qlik handles that section of export there is a workaround for it. If you try =if(isnull(Country),' ',Country)

    This should resolve your query 

  • Thank you Daniel.
    Is null checking condition is not working for date field, for text it works fine.

    Any ideas on how to handle it?

  • Hi Padma, I checked and =null() works for dates as well

Login to post a comment