topic Re: Previous dimension in QlikView

Previous dimension

Tue, 28 Jun 2016 14:26:46 GMT

Hello, Everybody!

I have an Issue:

	Mai
Volume (lb)	5000
Price ($)	150,00
Volume April (lb)	??

I want to show the previous month's volume, I've already tried with Range Sum, but once I make a filter by month (same dimension of this chart), do you guys know how to do that?

Grateful, Luiz Bisco

Re: Previous dimension

sunny_talwar — Tue, 28 Jun 2016 17:45:28 GMT

Try with Above() function.

Re: Previous dimension

Tue, 28 Jun 2016 18:35:10 GMT

It doesn't works or I did it wrong!

Re: Previous dimension

sunny_talwar — Tue, 28 Jun 2016 18:42:45 GMT

Would you be able to share a sample?

Re: Previous dimension

Tue, 28 Jun 2016 18:49:41 GMT

No, I can't share, I am in company. But here is the thing: I have a filter with monthname of arrival date and my chart has that same dimension.

But I want to show what happens in the previously either, do you know how can I do that?

Re: Previous dimension

sunny_talwar — Tue, 28 Jun 2016 19:04:43 GMT

Try this:

Above(Sum({<MonthField>}Sales)) * Avg(1)

Assumptions

1) Your expression was Sum(Sales)

2) Dimension is MonthField where you plan to make selections

Re: Previous dimension

Tue, 28 Jun 2016 19:23:53 GMT

Sunny, I want to select May and show April (one of expressions will show april, the others will show may)

Re: Previous dimension

sunny_talwar — Tue, 28 Jun 2016 19:58:13 GMT

Right, this is what it should do. Would you be able to provide few rows of dummy data to demonstrate how this can work?