Select the Min and Max salary from the excel column as filtered.

[QlikSenseBeginner]

1) Select the Min and Max salary value from the excel column 'Gross Salary' 

2) After which, Minus 500 dollars from the min value and add 500 to the max value identified.

3) Show the min and max result (after minus 500 and add 500) each in a KPI chart.

Write a set analysis to filter this. 

Employers	Gross Salary
ABC	3000
ABC	5583
ABC	3600
ABC	2500
ABC	7000
ABC	2500
ABC	2500
ABC	4333
ABC	7500
ABC	6000
ABC	2500
ABC	7100

Really hope you can help me with this.  Thanks. 

[pallavsi_08 · Accepted solution]

Hi,

You can use max and min to get the expected output.

Max([Gross_Salary])+500 as Max_Salary,
Min([Gross_Salary])-500 as Min_Salary,