Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
arpitkharkia
Creator III
Creator III

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
Specialist III
Specialist III

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

View solution in original post

5 Replies
sunny_talwar

May be like this

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

     Count(CLAIM_NO),

     Dimension/s,

Resident.....

Group By Dimension/s;

krishnacbe
Partner - Specialist III
Partner - Specialist III

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
Creator III
Creator III
Author

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
Specialist III
Specialist III

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?