topic SUM in QlikView

SUM

Mon, 13 Sep 2010 11:06:44 GMT

I have one table with columns: P_ID, Date, PR_ID, PRI_ID, PRICE

That says the price of a product for a specific day.

Now when I select some months so i get only the days from that month in the table en above te total price that mont.

This is clear I hope.

Now I want a graph that shows me every month the total PRICE so the same as the table but now for every month.

When I select the month 01-2010 in the table I get a total PRICE of 331527,37 and in the graph 3131,60

So there is a BIG difference.

Does somebody know what the problem is?

If you don`t understand my question please tell me.

Kind Regards,

Martijn

john_duffy — Mon, 13 Sep 2010 13:02:10 GMT

Hi Martijn.

Can you post a sample application using inline load and highlight the issue.

Thanks.

suniljain — Mon, 13 Sep 2010 13:07:22 GMT

In Table or graph . are you Suppressing null at either place ?.

Mon, 13 Sep 2010 13:26:09 GMT

This is what I have loaded.

here is the problem. I select the month and I get a different total price

suniljain — Mon, 13 Sep 2010 13:43:28 GMT

Martin,

Pls post Application . It will help us to solve this issue. From above screen shot I am not clear about where is problem.