topic Re: Ignore Dimension in Set Analysis But Use Value in the Expression in QlikView

Ignore Dimension in Set Analysis But Use Value in the Expression

louiswinter — Wed, 16 Dec 2015 22:16:40 GMT

I know the question has been asked multiple times regarding how to ignore a dimension in an expression but I can't find a solution that works for my situation.

Situation:

1. Straight table with DateA as the dimension.

2. Expressions that total values for the dimension - works fine.

3. An expression that shows total value for 3 months ago based on the dimension date - doesn't work. Can't use "Above" because the first 3 rows won't be populated.

Example attached, expression that doesn't work is in yellow.

Any ideas of how to accomplish this would be greatly appreciated.

Thanks,

Louis

Re: Ignore Dimension in Set Analysis But Use Value in the Expression

sunny_talwar — Thu, 17 Dec 2015 10:18:19 GMT

This?

I used above only -> If(Sum(Amount) > 0, Above(Sum({1<SalesDateMonthEnd>}Amount), 3))

Re: Ignore Dimension in Set Analysis But Use Value in the Expression

louiswinter — Thu, 17 Dec 2015 14:16:41 GMT

Awesome, thanks! I didn't know that Above could be used for anything other than existing chart values.

Re: Ignore Dimension in Set Analysis But Use Value in the Expression

sunny_talwar — Thu, 17 Dec 2015 15:35:58 GMT

Not sure what you mean when you say -> "Above could be used for anything other than existing chart values"

Re: Ignore Dimension in Set Analysis But Use Value in the Expression

louiswinter — Thu, 17 Dec 2015 15:40:59 GMT

I've only ever used it for something like Above([Column Name], #). I just didn't realize that Above could have functions within it, as with your solution. I learned something, thanks again.

Re: Ignore Dimension in Set Analysis But Use Value in the Expression

sunny_talwar — Thu, 17 Dec 2015 15:50:51 GMT

Oh ya, you surely can. You can see QlikView's help for more information on Above -> QlikView ‒ Above - chart function

Re: Ignore Dimension in Set Analysis But Use Value in the Expression

subbareddykm — Thu, 17 Dec 2015 15:59:08 GMT

Hi Sunny,

Do you have any idea on this?

How to do this?