Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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