topic Re: Year Issue in Chart in Qlik Learning Discussions

Year Issue in Chart

Anonymous — Wed, 12 Nov 2014 10:36:29 GMT

I am trying to create simple chart with Dimention Year with expression sum(sales)

i am getting one extra field with "_" after all the years in X axis.

i am not getting why i am getting it and how to avoid it. Can anyone helpme to resolve.

Regards,

Sandeep

Re: Year Issue in Chart

alexandros17 — Wed, 12 Nov 2014 10:39:14 GMT

The reason is that In your model there are sales not associated to any year, the - you see means null values, in your chart in the dimension tab check the "suppress when value is null" box, you shoult even take a look to your model (How's that there are sales without year?)

Re: Year Issue in Chart

Anonymous — Wed, 12 Nov 2014 10:50:10 GMT

Through Diemsion tab i have acheived it. but i am still confused. Can you explain more what i have to do in data model

Re: Year Issue in Chart

raviityou — Wed, 12 Nov 2014 11:00:29 GMT

hi,

try this hope it will help you

this is because you not suppressing the null value

check the suppress when value is Null

Re: Year Issue in Chart

Agis-Kalogiannis — Wed, 12 Nov 2014 11:18:35 GMT

Hi Sandeep

In your data model, there might be products that have never been sold or customers that might have not placed any orders.

All the above cases give us a Null value in the Facts table as a foreign key (since there is not existing Order to associate with them). This null is not associated with any year, so it appears as a separate value in your chart. That's why you see this extra value.

You can suppress it by following the above instructions.

I hope this clarifies the situation.

Regards

Agis

Re: Year Issue in Chart

alexandros17 — Wed, 12 Nov 2014 11:27:15 GMT

send me the image of your data model