Possible bug when creating dynamic report

Fri, 11 Dec 2015 13:18:48 GMT

Hi,

I've created a dynamic report and found a strange behaviour. I've finally managed to see a pattern and don't know if it's a bug or something I've overlooked.

Maybe someone here can shed some light on this

I'm loading inline tables and using the expressions in conditional to show/hide:

Dimensions: =SubStringCount(Concat(_Dimension_Flag, '|'), '1') and so on

Metrics: =SubStringCount(Concat(_Metric_Flag, '|'), '1') and so on

But whenever i use the selection box for a value that is over 9 the dimension or metric with the first corresponding number is also shown.

If I choose Dimension 10, Dimension 1 is also shown.

If I choose Dimension 13, Dimension 3 is also shown

If I choose Metric 11, Metric 1 is also shown

If I choose Metric 12, Metric 2 is also shown

Loading the data islands for the selections like this.

Dimension:

LOAD * INLINE [

_Dimension, _Dimension_Flag

D1,1

D2,2

D3,3

D4,4

D5,5

D6,6

D7,7

D8,8

D9,9

D10,10

D11,11

D12,12

D13,13

];

Metrics:

LOAD * INLINE [

_Metric, _Metric_Flag

x,1

y,2

z,3

a,4

b,5

c,6

d,7

e,8

f,9

g,10

h,11

i,12

];

topic Possible bug when creating dynamic report in QlikView

Possible bug when creating dynamic report