Skip to main content

App Development

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

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT 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.