topic Re: No data to display in a chart in QlikView

No data to display in a chart

alec1982 — Wed, 25 Jul 2012 14:35:22 GMT

Hi,

I have a chart that looks up sum of employees per region when the headquarter filed has a value of 1.

the expression that I am using is :

Sum(

if (Headquarters =1

, Employees

)

and the dimenssion is Region.

The chart is not showing any data. while if I put the fields in a table box then I see all of them.

I have tried "For testing" to change the exprission to Sum(Employees) and it worked out.

Not sure what's wrong with the main exprission!

Thanks for any help!!

Thanks,

Alec

Re: No data to display in a chart

Wed, 25 Jul 2012 14:41:11 GMT

Hi Alec,

You are looking for count not sum...

Change expression accordingly for answer

Regards

Kulbir

Re: No data to display in a chart

swuehl — Wed, 25 Jul 2012 14:41:44 GMT

How are the fields Headquarters, Region and Employees related to each other? Could it be that if(Headquarters = 1,..) doesn't return an unambiguous answer if evaluated in your context?

Re: No data to display in a chart

Anonymous — Wed, 25 Jul 2012 14:45:14 GMT

If the expression sum(Employees) works in the same chart, the problem is with the condition. Either you misspelt the field name "Headquarters", or there is no value "1", or there are no Employees data for Headquarters = 1. Try to add Headquarters as dimension, it may help to see.

Re: No data to display in a chart

alec1982 — Wed, 25 Jul 2012 14:47:41 GMT

here is a sample of the table bo. i have exported to excel.

I don't see any issue in the relationship among the three fields.

Region	Employees	Headquarters
Asia Pacific	2	1
USA	50	1
Asia Pacific	0	0
Asia Pacific	1	0
USA	8	1
Asia Pacific	15	1

Re: No data to display in a chart

Anonymous — Wed, 25 Jul 2012 14:52:02 GMT

Try this:

sum(Employees*Headquarters)

Re: No data to display in a chart

alec1982 — Wed, 25 Jul 2012 14:58:49 GMT

It is just a misspelling issue.

I really should be more careful and not bother other PPl before I look at it.

Thanks for all of you.