topic Difference Between selection in QlikView

Difference Between selection

Fri, 30 Apr 2010 14:33:17 GMT

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

Difference Between selection

johnw — Fri, 30 Apr 2010 21:06:17 GMT

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

I don't think I understand the question.

Difference Between selection

wizardo — Fri, 30 Apr 2010 22:50:11 GMT

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