Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to show my sales by region as follows :
Africa |
Americas |
Asia |
Europe |
Oceania |
However I am getting the following
Africa |
Americas |
Asia |
Europe |
Oceania |
- |
The "-" is part of my Asia total. I have checked the leading spaces etc etc and cannot see any issue? Any idea what can cause this?
Thanks!
hi
if you are using the field in dimension then in general tab of chart check the supress null value.
if you are using the field in Expression then in presentation tab check supress null value after selecting field.
Hi,
Could you please share the sample file.
Thanks,
Sai
Thanks Vishwaranjan. Supressing the Nulls is removing this element of my Asian sales, how do I correct the data so it shows the correct figure.
Hi, Dermot.
Normally, I would go back to the source data to check that the sales have been completed correctly. It is likely someone has put in sales data without populating the region field.
Trying to code a solution in QlikView could be risky if, in future, there is missing data for another region.
Regards,
Neil
Neil,
I figured that might be the issue and went back and added dummy fields in to cover the missing countries in each table, ie I now have matching countries and regions in each table. In these newly added countries I simply added in zeros so that I dont skew my data. Still not working though!!!
Dermot.
Hi, Dermot.
I don't think that would work as the sales data would not be associated with your dummy country. You will need to go back to your original data and check that every row of sales data has a region populated.
Regards,
Neil
Dermot
In your load script you could for all the null regions replace them with some text, mey something like 'Undefined'.
if ( isnull ( [Region] ) , 'Undefined' , [Region] ) as [Region]
Then as ngulliver suggests you can select on those with Region undefined to see why they are loike that.
Best Regards, Bill