Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Difference Between selection

Hi,

i have to make a formula who is the difference between a selection who i do.

Example, i have a table who contain the variable A B C, if i make a selection ( A B for example) my formula can calculate A - B.

Thank You

2 Replies
johnw
Champion III
Champion III

max(FieldName)-min(FieldName) ???

I don't think I understand the question.

wizardo
Creator III
Creator III

hi there,

maybe somthing like this?

i put this in a textbox.

=if(GetSelectedCount(your_Fieldname)=2,subfield(GetFieldSelections(your_Fieldname),',',2)-subfield(GetFieldSelections(your_Fieldname),',',1),'please select only two values in field your_Fieldname')

Mansyno