topic Re: Wrong Values displayed in the Grid Chart in QlikView

Wrong Values displayed in the Grid Chart

manideep78 — Tue, 05 Aug 2014 11:58:54 GMT

Dear Community,

I have an issue with the Grid Chart.

Dimensions:

Country

Year

Product

Expression =Sum(Sales).

As you can see in the below Grid Chart, the plot is splitting according to the values. But When I placing the cursor on any partition it showing 700 instead of corresponding values. When I place cursor on red it should display 5000, green =700, blue=500. But for every partition it is displaying 700.

Can you please help me where I am going wrong.

Thanks & Regards

Manideep

Re: Wrong Values displayed in the Grid Chart

Yousef_Amarneh — Tue, 05 Aug 2014 12:10:09 GMT

try to recreate your chart again, you might missed something.

Re: Wrong Values displayed in the Grid Chart

manideep78 — Tue, 05 Aug 2014 12:13:09 GMT

Hi Yousef,

Thanks for the response. I tried it again but I got the same problem.

Regards

Manideep

Re: Wrong Values displayed in the Grid Chart

ashfaq_haseeb — Tue, 05 Aug 2014 12:16:06 GMT

Hi,

Can you share sample app.

Regards

ASHFAQ

Re: Wrong Values displayed in the Grid Chart

Yousef_Amarneh — Tue, 05 Aug 2014 12:17:04 GMT

Please share an example

Re: Wrong Values displayed in the Grid Chart

Tue, 05 Aug 2014 12:20:37 GMT

Hi Manideep,

Could you attach a sample of your app?

Also, just to check: your expression says sum(Sales) and on the chart you are showing values for [Rates] instead of [Sales]. Is this correct? Maybe the sum is of a different field?

Re: Wrong Values displayed in the Grid Chart

manideep78 — Tue, 05 Aug 2014 12:20:37 GMT

Attached sample application

Re: Wrong Values displayed in the Grid Chart

manideep78 — Tue, 05 Aug 2014 12:22:35 GMT

Hi Jose,

Sum(Sales) is correct actually. Small misunderstanding in the expression title.

Re: Wrong Values displayed in the Grid Chart

Yousef_Amarneh — Tue, 05 Aug 2014 12:31:53 GMT

check how many dimension and expression you shold use in this type of charts and what is the purpose to use it, try to play with the dimension order, there is something wrong in the report itself

Re: Wrong Values displayed in the Grid Chart

Tue, 05 Aug 2014 12:33:41 GMT

It looks like a bug. I created the same chart from the same sample data and I noticed that the checkbox "Text as popup" is deactivated. Maybe to avoid the confusion of the displayed values...

I whould check with Qlik's support team.

Re: Wrong Values displayed in the Grid Chart

manideep78 — Tue, 05 Aug 2014 12:35:49 GMT

Yousef,

I wanted to check Sales for each product in the year for each Region (like pie chart.) so that I am using 3 dimensions here. It is appropriate that we can use 3 dimensions in this scenario.

Re: Re: Wrong Values displayed in the Grid Chart

Yousef_Amarneh — Tue, 05 Aug 2014 12:39:22 GMT

use the bar chart instead, it's working, please see the attached file

Re: Wrong Values displayed in the Grid Chart

male_carrasco — Tue, 05 Aug 2014 12:39:30 GMT

Hi,

attached a example.

Ale

Re: Wrong Values displayed in the Grid Chart

Tue, 05 Aug 2014 12:43:38 GMT

Hi,

Try the below expression

=Sum(Total Aggr(Sum(Sales),Year)

Re: Wrong Values displayed in the Grid Chart

manideep78 — Tue, 05 Aug 2014 12:44:36 GMT

Hi Alejandra Carrasco

In your example, the pie chart shows correct values. But I need to see all those values at a time for all dimensions. So I took Grid Chart. If I Clear selections I could see all the Country, Product and Year as Dimensions. So I need sum(sales) for all those dimensions.

Re: Wrong Values displayed in the Grid Chart

manideep78 — Tue, 05 Aug 2014 12:45:56 GMT

No Luck Soumya Jigajinni

Re: Re: Wrong Values displayed in the Grid Chart

ashfaq_haseeb — Tue, 05 Aug 2014 12:49:27 GMT

Hi,

May be something like this.

Regards

ASHFAQ

Re: Wrong Values displayed in the Grid Chart

male_carrasco — Tue, 05 Aug 2014 13:15:49 GMT

check out this way.

Ale

Re: Wrong Values displayed in the Grid Chart

manideep78 — Tue, 05 Aug 2014 13:25:36 GMT

I already tried this in the Pie Chart. Can't I get this in the Grid Chart?

Re: Wrong Values displayed in the Grid Chart

manideep78 — Tue, 05 Aug 2014 13:28:11 GMT

Hi Alejandra,

I could get this with other charts. I am confirming that whether I can get this functionality in the Grid Chart. I think this is a bug in the Grid Chart. Thanks for the effort.