Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Previous dimension

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

1 Solution

Accepted Solutions

Re: Previous dimension

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

7 Replies

Re: Previous dimension

Try with Above() function.

Not applicable

Re: Previous dimension

It doesn't works or I did it wrong!

Re: Previous dimension

Would you be able to share a sample?

Not applicable

Re: Previous dimension

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

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

Not applicable

Re: Previous dimension

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

Re: Previous dimension

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