Capping in Qlikview

[anushree1]

Hi All,

I have a requirement to cap the values >=vmin and<=vmax, so in case it is just the capping of a number greater than vmax i would use ragemax or ragemin as expected but here i need to do it both the ways.

For eg:

My dataset is as below:

Dim	Val
A	10
B	54
C	32
D	85
E	12
F	65

and I want to create a table with expected col like below:

Dim	Val	Expected
A	10	20
B	54	50
C	32	32
D	85	50
E	12	20
F	65	50

where vmin=20 and vmax=50

Could anyone please help me on the same.

Values of vmin and vmax are dynamic and shall change based on user input

Attached a sample for the reference

[sunny_talwar · Accepted solution]

Seems like you need this on the front end... try this

Sum(Aggr(If(Sum(Val) < vmin, vmin, If(Sum(Val) > vmax, vmax, Sum(Val))), Dim))