topic Re: Calculation Question (Set Analysis vs. "If") in QlikView

Calculation Question (Set Analysis vs. "If")

tmumaw — Mon, 14 May 2012 12:15:10 GMT

Hello All,

I am have a small issue trying to get something to work using set analysis and thought maybe someone out here could help. The first statement works fine, but the second one using set analysis does not. I was wondering if I am doing something wrong. Thanks Thom

1) Sum(if(Contract_End_Date_Num >= Roll_Out_Date_Num, ExtendedAmount))

2) Sum({<Contract_End_Date_Num = {">= Roll_Out_Date_Num"}>} ExtendedAmount)

Re: Calculation Question (Set Analysis vs. "If")

jagannalla — Mon, 14 May 2012 12:43:46 GMT

Tmumaw,

Yes it is wrong way of using set analysis.

Note:

Your first expression will gives the data in loading process i.e 1 by 1 check. When coming to second expression you should assign value to compare.

For example:

sum( {$<Year = {2000}, Region = {US, SE, DE, UK, FR}>} Sales )

sum( {$<Year = {“>1978<2004”}>} Sales )

coming to your expression you should compare either max or min of Roll_Out_Date_Num.

Sum({<Contract_End_Date_Num = {">=$(= Min(Roll_Out_Date_Num))"}>} ExtendedAmount)

Hope it helps you..

Cheers !

Re: Calculation Question (Set Analysis vs. "If")

tmumaw — Mon, 14 May 2012 12:48:37 GMT

Thanks Jagan that worked perfectly. You don't know how long I have been looking at that statement wondering why it would not work. Have a great day. I know I will now.

Thom

Re: Calculation Question (Set Analysis vs. "If")

jagannalla — Mon, 14 May 2012 13:11:20 GMT

I didn't get what you said? But one think i want to know whether you had find solution yourself or my solution helped you?

If you find solution can you share with us. B'coz you ticked your post as correct.

Re: Calculation Question (Set Analysis vs. "If")

tmumaw — Mon, 14 May 2012 14:22:22 GMT

Your's worked perfectly. Thanks