Export issue in pivot table with different number format in the same expression
I am working on a requirement, in which we are showing a Pivot table in which the expression has multiple number format based on the dimension field value. We are able to achieve the different number format, however, when we export the table into excel, the value of the numbers are getting exported as text, which as I understand is expected when you select 'Expression Default' format in the number tab of the chart property.
Please find the attached workbook with a mock version of what we are trying to achieve.
Below are some screenshots
Pivot Table in QlikView
Excel Export :
Instead of the value getting exported as text in excel, we want to get them as numbers in the defined format.
Note: One thing we found out is that, if the entire expression uses the same number format in the 'num()' function even if there are multiple if else condition with different formulae, the export still retains the values as numbers but the format resets to default.
Thanks for the reply, however this is not the solution i am looking for. Doing this will keep the format of the entire column and row as fixed with two decimal. What i am looking for is to have two different formats in the same expression for two different values of dimensions amd to export the same as numbers in excel. Please have a look at the attached qvw file, it will clear the requirements.
We also came to the same conclusion, there is no way to retain the format using the "send to excel" option. For not we decided to educate the user about copying the data manually and the pasting it in excel.