Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
May be like this
LOAD Sum(If(Status_CD = 13, OP),
Count(CLAIM_NO),
Dimension/s,
Resident.....
Group By Dimension/s;
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.
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?
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
Do you have a sample you can share with the expected output?