Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
ilanbaruch
Specialist
Specialist

self service / ad-hoc table

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

1 Solution

Accepted Solutions
sunny_talwar

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

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

View solution in original post

4 Replies
sunny_talwar

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

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

settu_periasamy
Master III
Master III

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
Specialist
Specialist
Author

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
Specialist
Specialist
Author

Sunny,

thank you very much, solved!