topic Re: Selection of calculated dimension in QlikView

Selection of calculated dimension

arpitkharkia — Mon, 07 Aug 2017 06:15:24 GMT

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!

Re: Selection of calculated dimension

Anil_Babu_Samineni — Mon, 07 Aug 2017 06:17:52 GMT

I am not sure i understand, May be this

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

Re: Selection of calculated dimension

Anonymous — Mon, 07 Aug 2017 08:17:43 GMT

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

Re: Selection of calculated dimension

tresB — Mon, 07 Aug 2017 09:13:53 GMT

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.

Re: Selection of calculated dimension

arpitkharkia — Mon, 07 Aug 2017 11:19:55 GMT

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.

Re: Selection of calculated dimension

tresB — Mon, 07 Aug 2017 11:24:04 GMT

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.

Re: Selection of calculated dimension

arpitkharkia — Mon, 07 Aug 2017 11:27:46 GMT

can i use the following expression in script?

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

Re: Selection of calculated dimension

tresB — Mon, 07 Aug 2017 12:11:00 GMT

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.