Problem with dimension

[#1]

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

[Miguel_Angel_Baeyens]

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

[#3]

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.

[Miguel_Angel_Baeyens]

Hi,

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

Regards.

Miguel