Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

arpitkharkia
Contributor

Formula as dimension

I have the following expression in the front end:

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


I need the output of the above expression to be bucketized into 5 buckets of 20% each. Then i have to use that dimension in a chart. I tried using a variable but not able to apply.


Help appreciated!

1 Solution

Accepted Solutions
MVP
MVP

Re: Formula as dimension

May be like:

Class(Aggr(count({<STATUS_CD={13}>}OP)/count(CLAIM_NO), YourDimension), 0.2)

13 Replies

Re: Formula as dimension

Your expression this?

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


Note - How you want to show bucket. Can you explain little more


Life is so rich, and we need to respect to the life !!!
MVP
MVP

Re: Formula as dimension

May be like:

Class(Aggr(count({<STATUS_CD={13}>}OP)/count(CLAIM_NO), YourDimension), 0.2)

arpitkharkia
Contributor

Re: Formula as dimension

so this is formula to calculate HR. The result will be in percentage so i want to have buckets of percent and show how many case falls in each of the bucket. so how many cases are there for my HR in 0-20% and so on.

arpitkharkia
Contributor

Re: Formula as dimension

You want me to this in the front end as calculated dimension or through resident load in the script?

MVP
MVP

Re: Formula as dimension

Front-end?

arpitkharkia
Contributor

Re: Formula as dimension

Sorry if there is any confusion. So i have to use it in the script right?

MVP
MVP

Re: Formula as dimension

You CAN do it in front-end itself.

arpitkharkia
Contributor

Re: Formula as dimension

its working just fine. Thanks a lot. One more thing i want to label the different classes accordingly. How can i do that?

MVP
MVP

Re: Formula as dimension

You can probably do so using string manipulation functions. Try to share a sample explaining your expected output, may be I could help better.

Community Browser