Qlik Community

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 
Search instead for 
Did you mean: 
krishna20
Specialist II
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:

LOAD * INLINE [

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 . 

ABCD
-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)
1 Reply
krishna20
Specialist II
Specialist II
Author

Any clue??