topic Re: compare Each List Value in QlikView

compare Each List Value

Tue, 22 Apr 2014 02:15:35 GMT

Hi, ALL

Someone know that?

I want show like this

[Month] [(MonthSales)] [(LastMonthSales)] [Compare(%)]

Now, I struggleed with LastMonthSales.

I thought ==>

=if((Month-1 >0), Sum ({1<Month={"Month-1"}>}Sale), 'no')

but, not working.

how to resolve this..

thank you.

trey_bayne — Tue, 22 Apr 2014 02:49:26 GMT

Try using Above(Sales1) in the expression

trey_bayne — Tue, 22 Apr 2014 02:52:08 GMT

Also, if you want to get rid of the null you can do something like this in Sales2.

=if(isnull(Above(Sales1)),Sales1,Above(Sales1))

Tue, 22 Apr 2014 02:59:26 GMT

Trey, Thank you

great thank you!!!

I solved it!