Capping in Qlikview

anushree1 — Fri, 02 Nov 2018 11:22:19 GMT

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

Re: Capping in Qlikview

niclaz79 — Fri, 02 Nov 2018 11:30:09 GMT

if(Val < vMin, vMin,

if(Val > vMax, vMax, Val)) as Val

topic Capping in Qlikview in QlikView

Capping in Qlikview

Re: Capping in Qlikview