Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Possible bug when creating dynamic report

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

];

0 Replies