topic Dash in Dimensions in QlikView

Dash in Dimensions

dmac1971 — Fri, 06 Dec 2013 12:47:04 GMT

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!

Re: Dash in Dimensions

Fri, 06 Dec 2013 12:50:18 GMT

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.

Re: Dash in Dimensions

Fri, 06 Dec 2013 12:50:25 GMT

Hi,

Could you please share the sample file.

Thanks,

Sai

Re: Dash in Dimensions

dmac1971 — Fri, 06 Dec 2013 12:59:22 GMT

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.

Re: Dash in Dimensions

ngulliver — Fri, 06 Dec 2013 14:22:01 GMT

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

Re: Dash in Dimensions

dmac1971 — Fri, 06 Dec 2013 14:28:26 GMT

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.

Re: Dash in Dimensions

ngulliver — Fri, 06 Dec 2013 14:46:45 GMT

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

Re: Dash in Dimensions

Anonymous — Sat, 07 Dec 2013 18:39:20 GMT

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