I'm trying to pull data from a SQL database into Qlik Sense. However part of the data is appearing as "-" in the data preview. I know that the data is not null in my database. Does anyone know what could be causing this?
have yu used any joins?
Did you used any filters ? If YES remove.
Did you pull the data from individual tables? What are the results?If No, reload the tables one by one and work on QVDs.
Are you using any transformation on Quantity,BillingPrice,ExchangeRate,UserPrice? If YES, remove and reload.
Hope this will help you.
Retrieving data ...