Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ruben_moya
Creator
Creator

Set analysis. Dimension compared to another dimension

Dear experts,

This is my situation:

-I have a field 'prediction' with values from 0 to 1

-I have a field called 'prediction_ID' that is unique 

-I have created, in a separated table, a field called threshold that is basically class(Prediccion,0.01) and looks like this:

ruben_moya_0-1652284919211.png

What I would like to achieve is to be able to sum the amount of prediction IDs whose prediciton values are greater than the thresholds. For a specific threshol the formula would be something like:

count({< Prediction={">=0,02"}>}Prediction_ID)

What I need is to be able to use a formula that allows me to tell, for each threshold, how many predictios have been higher.

I tried different options, but none worked:

count({<Prediction= {"=Prediction>= threshold "}>}Prediction_ID)
count({< Prediction={">=threshold "}>}Prediction_ID)

Is there any way to be able to filter in set anaylisis one dimension based on the value of another dimension?

I tried to be clear, if you have any questions please ask

Thanks a lot in advance

Labels (1)
2 Replies
vchuprina
Specialist
Specialist

Hi,

Try this:

Count({<Prediction_ID= {"=([Prediction]>=[threshold])" } >} Prediction_ID)

Regards,

Vitalii

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").
ruben_moya
Creator
Creator
Author

Hi @vchuprina ,

thanks for your reply. That solution only works when there is one value of threshold selected.