Front end formula in the back end

[arpitkharkia]

I want to write the following formula in the back end to bucketize the output

sum({<STATUS_CD=13>}OP)/count(CLAIM_NO)

These columns are availablein the table in the back end.

Help appreciated!

[sunny_talwar]

May be like this

LOAD Sum(If(Status_CD = 13, OP),

     Count(CLAIM_NO),

     Dimension/s,

Resident.....

Group By Dimension/s;

[krishnacbe]

Hi,

If you need it as table data, I too agree with Sunny's Solution .

If you need to just move the formula to backend you can thing of Variables.

SET vExpression = sum({<STATUS_CD=13>}OP)/count(CLAIM_NO);

you can use the Variable in front end.

[arpitkharkia]

Thanks for the reply Sunny and Krishnapriya!

i was thinking of the same thing of having the variable in the front end then how to bucketize that into 5 buckets and use that as dimension?

[rahulpawarb · Accepted solution]

To achieve the bucketing functionality you can opt below options:

1. Class Function  class ‒ QlikView

2. If Statements if ‒ QlikView

Hope this will help.

Regards!

Rahul Pawar

[sunny_talwar]

Do you have a sample you can share with the expected output?