topic How can you limit a dimension in QlikView

How can you limit a dimension

Wed, 14 Sep 2011 14:02:50 GMT

Hello,

this might be really simple, but i can't think of an elegant way of doing it. For example you have a graph with a monthly value, and the data is retrieved only half of the last month, because then is when you last refreshed the report. How can i make the chart ommit the incomplete month?

See attached image, in this case in august the data was retrieved only partially, and i dont want to show it. I don't want the user to filter it himself, i want to do it by default. So it would end up only Jan - Jul values. And let's assume the metric is something like sum(apples)

Selecting only complete month data from the database is what it comes to my mind, but maybe there is a more elegant way?

Thanks!

How can you limit a dimension

Wed, 14 Sep 2011 14:36:03 GMT

Hello,

I would create a calculated dimension in the chart:

=if(Month(MyDate) < Month(Today()), Month(MyDate))

And uncheck "Show Nulls" in chart props --> dimension.

HtH

Roland

P.S.:

You can also use the definition above within groups.

How can you limit a dimension

Wed, 14 Sep 2011 14:42:14 GMT

Yes, this was indeed easy I guess i'm just tired. Thanks!