I have a set of data with posting codes and the amount posted against them each period- I want to put these into a pivot table, however there are some periods where certain codes have nothing posted against them. When I export the data from the table, these are assigned a value of '-', rather than 0, which messes up the template which I have to populate with this data. After researching and trying to work out how to convert these to 0, I found something about an option to set chart properties to 'populate missing cells' within Qlik View, which sounds like it would be ideal, but there doesn't appear to be an equivalent in Qlik Sense.
I have also tried several methods of manipulating the data to convert these to 0, but the issue is that these are not true null values, but rather missing values (type two, I believe!) so there is no data to convert. Does anyone have any suggestions on how to do this?