topic Missing data between 2 charts Puzzle in QlikView

Missing data between 2 charts Puzzle

Fri, 17 Jun 2011 15:47:12 GMT

Hi Guys

I have 2 tree maps,

One is based on the demensions Activity = 'Customer Service'

Type of Query

Expression is [Type of Query ] = calculation is if(Activity='Customer Service',sum(Number))

This works perfectly,

The 2nd Tree map was Cloned from this one and basically it is looking at cycle times,

Demensions are the same,

based on the demensions Activity = 'Customer Service'

Type of Query

Expression is [Time to complete ] = calculation is if(Activity='Customer Service',sum(Number)*[Time to complete])/60

This also works perfectly, at least it was , I have noticed that one activity in particular is not reporting correctly, on the first Chart it is numerical value of 13,610 ( which is correct) I would expect to see it on the second chart with a value of 58, its is not.

Now in saying that this QV doc is pulled from numerous Excel sheets and this particular field is only common the 3 particular Areas, once I drill into those areas on the list box function the correct data comes up. But without the drill down it is not calculated as part of the total.

Can anyone help ?

Thanks

I only have a personal edition QV license so not sure I can post a sample

Missing data between 2 charts Puzzle

erichshiino — Tue, 21 Jun 2011 21:20:52 GMT

I don't think it's so easy to identify this problem with the description.

We may not be able to send you a solution, but you can share a sample with the community.

Re: Missing data between 2 charts Puzzle

Wed, 22 Jun 2011 08:26:26 GMT

Hi Erich

See attached ( Ive made a sample ), the query is on Auto Confirmations,

When nothing is selected in list box Customer service has 1088 Auto Confimations, we would expect Customer Service to have 4.71 ( which is 1088 mulitplied by 26 divided by 60)

It has nothing.

If I select Mark and then BBI for Branch it displays correctly as 4.71 , Do you know why it wouldnt be accounting that 4.71 as part of the total unless the selections have occured ?

Thanks

Re: Missing data between 2 charts Puzzle

kaushiknsolanki — Wed, 22 Jun 2011 09:01:32 GMT

Hi,

Here is an example, Have a look at this.

Regards,

Kaushik Solanki

Re: Missing data between 2 charts Puzzle

Wed, 22 Jun 2011 09:05:58 GMT

Hey Kaushik,

I still only have personal edition ( Awaiting licenses and stuff) Any chance you'd be able to talk me through any discrepencies you have found please ?

Thanks

Re: Missing data between 2 charts Puzzle

kaushiknsolanki — Wed, 22 Jun 2011 09:44:05 GMT

Hi,

Remove the calculated dimension from both chart.

Use below expression in respective charts.

=(sum({$<Activity = {"*Customer Service*"}>}Number)*sum({$<Activity = {"*Customer Service*"}>}distinct [Time to complete]))/60

=sum({$<Activity = {"*Customer Service*"}>}Number)

Regards,

Kaushik Solanki

Re: Missing data between 2 charts Puzzle

Wed, 22 Jun 2011 11:36:50 GMT

Thanks Kaushik

Works perfect