Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
With my current requirement, I am asking Qlikview to show all product values and populate missing values with a '0'. However when I export to excel, the populated 0 values are formatted as text when I need them to be formatted as a number! The object I am exporting is a pivot table. Is there any work around for this? Thanks!
Things I have tried.
My feeling is Qlikview is programmed to populate missing cells with only text values rather than numeric.