topic Re: self service / ad-hoc table in QlikView

self service / ad-hoc table

ilanbaruch — Tue, 17 May 2016 17:02:23 GMT

hi all,

i have a self service table based on 35 conditional dimension:

SubStringCount(Concat(Dimension_Pick, '|'), 'Supplier')

i added another dimension and is working good (as expected) on developer but when i update the model into access point

it is not showing the dimension in the table.

tried to change the name in the dimension list still not working ..

any ideas??

advanced thanks

sunny_talwar — Tue, 17 May 2016 17:06:02 GMT

Not sure if this will make any difference, but can you try adding DISTINCT?

SubStringCount(Concat(DISTINCT Dimension_Pick, '|'), 'Supplier')

settu_periasamy — Tue, 17 May 2016 17:07:43 GMT

Is only one dimension not showing (newly added) or entire dimensions not showing?

Can you check the dimension name(assume you are loading labels via external file -excel) ?

ilanbaruch — Tue, 17 May 2016 17:16:59 GMT

all is working as usual, only the new one is not showing and only on access point.

on developer its working

all names is in the script, no excel

ilanbaruch — Wed, 18 May 2016 11:08:16 GMT

Sunny,

thank you very much, solved!