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: 
Not applicable

Use dimension value as fieldname in expression

Hi.

I have a dataset that is Customer and 80+ factors from 0-1

I need to rank the top ten factors.

To do this, i have loaded the factor fieldnames into a data island called dimensions.

My theory is to create a chart and set dimension as dimension, and input the dimension value into the expression, so i get avg([value of dimension]).

Is this doable?

I attached an example.

2 Replies
anbu1984
Master III
Master III

Check this app

anlonghi2
Creator II
Creator II

Hi Jon,

try using cross table in script and rank function in expression

Attached your app with this approach (I added some extra factors to check the app)

Best regards