Selection of calculated dimension

[arpitkharkia]

i have the following calculated dimension:

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

Here buckets are getting created 0-20,20-40 and so on till 100. I want to create an action where one of the fields has to be selected on click of a text box.

Help Appreciated!

[Anil_Babu_Samineni]

I am not sure i understand, May be this

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

[Anonymous]

Hi

Please check the attached qvw. i have created a field ;using class and then added button to select that field.

Mark this answer as correct if it is useful to you

[tresesco]

You can't directly make a selection happen in calculated dimension using action, but indirectly. You can use the same class range to select the values from the original field and see the effect in the calculated (classed) field.

Otherwise, create the class in the script and apply the action on the new field coming from script.

[arpitkharkia]

My calculated dimension's expression is a little complex. I dont think i can directly use it the the way you are showing in the above example.

[tresesco]

Yes, it would not be as easy as you see above. But we may give a try if you could provide a sample qvw. Else, create the class in the script as a field, that would make your action work easily.

[arpitkharkia]

can i use the following expression in script?

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

[tresesco]

Aggr() and set analysis are not supported in the script. Therefore, you can't directly use the same expression in the script as it is. However, with proper join/group by (along with aggregation functions) you could possibly achieve similar in the script.