I am loading data from an xls. It has some columns that need to represent both integer values as well as percentage values. For example, it has values as follows;
When I load them into Qlikview onto a pivot table, I either get all integer values or all percentage values.
There have been previous posts and I have tried the solution but they have not worked for me.
I have also tried the following steps
- Document properities
- Numbers tab
- Mark the field in question
- Uncheck "Survive reload"
- Reload the document
but it does not work, and the first time I tried it the entire pivot table got cleared.
Can someone please advise me on what to do?
Solved! Go to Solution.
Ashish, I have attached a downsized version of the file.
Thanks for your reply Martina. I tried your suggestion, but its showing integers and where the values shouls in percent are showing as zeros.