topic Re: Expression Help in QlikView

Expression Help

Thu, 03 Sep 2015 14:56:04 GMT

HI Experts

I have a targets table against each the branches

but I want to change the calculation for one branch in the expression in table

ie., All Branch Daily Target is 400 but Particularly I want to change the Daily Target for branch 1017 as 1200

All Branch Monthly Target is 12000 but Particularly I want to change the Monthly Target for branch 1017 as 36000 in the Table

Please Suggest

how to write the expression for that

Please find the Sample Data attached

Desired Output

Re: Expression Help

settu_periasamy — Thu, 03 Sep 2015 15:01:55 GMT

Try this

=if([Branch Number]='1017',1200,

Sum(AGGR([Daily Target],[Branch Number],[Branch Manager])))

=if([Branch Number]='1017',36000,

Sum(AGGR([Monthly Target],[Branch Number],[Branch Manager])))

Re: Expression Help

Kushal_Chawda — Thu, 03 Sep 2015 15:02:29 GMT

For Daily Target

=if([Branch Number]='1017',1200, Sum([Daily Target]))

For Monthly Target

=if([Branch Number]='1017',36000, [Monthly Target])

Re: Expression Help

cspencer3 — Thu, 03 Sep 2015 15:03:02 GMT

Why are you using sum(AGGR) in your expression. Just do the sum of 'Daily Target' for the first expression and sum of 'Monthly Target' in your second. In your data the numbers are the proper number you were looking for..

Re: Expression Help

Thu, 03 Sep 2015 15:45:54 GMT

Please look at attachment

Re: Expression Help

Thu, 03 Sep 2015 16:10:16 GMT

HI All

Thank you

Apologize

I missed a point here,

the monthly & Daily targets are changing each month for all branches

All Branch Daily Target is 400 but Particularly I want to change the Daily Target for branch 1017 as 400*3 = 1200

All Branch Monthly Target is 12000 but Particularly I want to change the Monthly Target for branch 1017 as 12000*3 = 36000 in the Table

Please Suggest

Re: Expression Help

settu_periasamy — Thu, 03 Sep 2015 16:27:00 GMT

Hi,

Create a Variable and you can give the input value as multiplier.

check the attachment may be helpful.

Re: Expression Help

Thu, 03 Sep 2015 16:41:45 GMT

HI Settu

Thanks

I will implement your suggestion in my app and Try now