I've uploaded data via Excel to create visualizations from it. Despite only about half of the fields being (%) format, they all came through as (%). Is there a way within Qlik to format each row based on the intended format?
In Qlik, formatting is managed per column, not per row. Instead of pivoting your Excel data by month, you could pivot it by Metric (transpose metric and month), in which case each metric could have its own format. This would also make more sense insofar as the data model, I think...
