topic Problem with dimension in QlikView

Problem with dimension

Wed, 04 Jan 2012 10:22:48 GMT

Hi I have a bar chart with a count expresison, using a date dimension and I need to use the same expression in a gauge chart. However when I use the gauge chart it ignores the dimension, and as such qlikview aggregates a lot of records and the count result is not what I wan't. Is it possible to prevent automatic aggregation somehow?

Thank you in advance

Re: Problem with dimension

Miguel_Angel_Baeyens — Wed, 04 Jan 2012 10:32:23 GMT

Hi,

Indeed, gauge charts don't have dimensions, and if you set any, you will get unexpected results. You can always use set analysis to get a subset of your data to be shown in that gauge chart:

Sum({< DateMonth = {1, 2, 3}  >} Sales)

So the gauge will display the sum of Sales for values 1, 2 and 3 in field DateMonth.

Hope that helps.

Miguel

Problem with dimension

Wed, 04 Jan 2012 10:39:58 GMT

I already tried using DATE=, in the set analysis. This would calculate using all the dates existent, but it still didn't work.

Thanks anyway for your help.

Problem with dimension

Miguel_Angel_Baeyens — Wed, 04 Jan 2012 10:42:51 GMT

Hi,

Then please post some sample data and the expected result, or elaborate your actual requirements.

Regards.

Miguel