Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

arpitkharkia
New Contributor II

Front end formula in the back end

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!

1 Solution

Accepted Solutions
rahulpawarb
Valued Contributor II

Re: Front end formula in the back end

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

5 Replies
MVP
MVP

Re: Front end formula in the back end

May be like this

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

     Count(CLAIM_NO),

     Dimension/s,

Resident.....

Group By Dimension/s;

krishnacbe
Valued Contributor III

Re: Front end formula in the back end

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
New Contributor II

Re: Front end formula in the back end

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
Valued Contributor II

Re: Front end formula in the back end

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

MVP
MVP

Re: Front end formula in the back end

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