How to create % slab range for multiple measures

krishna20 — Wed, 31 Mar 2021 14:43:29 GMT

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 .

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

Re: How to create % slab range for multiple measures

krishna20 — Wed, 31 Mar 2021 02:28:25 GMT

Any clue??

topic Re: How to create % slab range for multiple measures in QlikView

How to create % slab range for multiple measures

Re: How to create % slab range for multiple measures