# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for
Did you mean:
Specialist II

## How to create % slab range for multiple measures

Hi Folks,

How to create a %slab range to effect on multiple measures in Pivot or straight table.

For Eg;

Slab_Range:

Start, End, Depth_Slab

, 0, 'No Deal'
0, 5,'<= -5%'

5, 10, '-5% to -10%'
10, 15, '-10% to -15%'
15,20, '-15% to -20%'
20,25 , '-20% to -25%'
25,30, '-25% to -30%'
30,35, '-30% to -35%'
35,40, '-35% to -40%'
40,45,'-40% to -45%'
45,50,'-45% to -60%'
50,55,'-50% to -55%'
55,60,'-55% to -60%'
60,65,'-60% to -65%'
65,70,'-65% to -70%'
70,75,'-70% to -75%'
75,80,'-75% to -80%'
80,85,'-80% to -85%'
85,90,'-85% to -90%'
90,95,'-90% to -95%'
95,100,'-95% to -100%'
];

I have four different measures .

 A B C D -10% -20% -15% -40% -20% -12% -13% -20% -25% -15% -16% -45% -55% -65% -70% -9%

Whenever I select the slab range that should affect all four measures and the values should be filtered out based on the range selected. I don't want to create 4 different slab ranges for each metric. Single slab range should affect all measures. Could anyone suggest to me how to achieve this logic??

Regards

Krishna

Labels (3)