expression logic

Tue, 02 Dec 2014 07:06:37 GMT

Dear All,

I have an expression as

((Sum({<[W1]*[F-1])/sum({<[W1])),

(Sum({<[W2]*[F-2])/sum({<[W2])), (Sum({<[W3]*[F-3])/sum({<[W3])), (Sum({<[W4]*[F-4])/sum({<[W4])), (Sum({<[W5]*[F-5])/sum({<[W5])), (Sum({<[W6]*[F-6])/sum({<[W6])), (Sum({<[W7]*[F-7])/sum({<[W7])), (Sum({<[W8]*[F-8])/sum({<[W8]))

)/8

and i want to create a list box where there are field as 8Week,2week,4week,6week as

So on clicking i got forcasting of 8 week as per the default expression and when i click on 4week then i got Forecasting of

((Sum({<[W1]*[F-1])/sum({<[W1])), (Sum({<[W2]*[F-2])/sum({<[W2])), (Sum({<[W3]*[F-3])/sum({<[W3])), (Sum({<[W4]*[F-4])/sum({<[W4]))

)/4

and when i click on 6 week then

((Sum({<[W1]*[F-1])/sum({<[W1])), (Sum({<[W2]*[F-2])/sum({<[W2])), (Sum({<[W3]*[F-3])/sum({<[W3])),

(Sum({<[W4]*[F-4])/sum({<[W4])), (Sum({<[W5]*[F-5])/sum({<[W5])), (Sum({<[W6]*[F-6])/sum({<[W6]))

)/6

Please tell me the set expression for this..

Re: expression logic

Peter_Cammaert — Tue, 02 Dec 2014 07:49:20 GMT

Maybe there is an easier way to do this, by using a slider and a variable. But then your question is already so specific... Can you give us an idea of how the forecasting data is created/available in your data model?

Peter

topic Re: expression logic in QlikView

expression logic

Re: expression logic