Hide Prefix qlik sense issue

[joeybird]

Hi

I am using qlik sense, and I am trying to hide a column to stop users accessing dimension in edit mode in the qlik server hub. But I have an issue

this works well

SET HidePrefix = '%';

CustomerID AS %CustomerID

The issue I have is that I am using CustomerID in the set analysis for a KPI which I need, how do I

count(CustomerID)... This now fails in KPI as CustomerID is hidden in the load.

Please help

[sunny_talwar · Accepted solution]

Can you do this

Count(%CustomerID)

[joeybird]

Hi

Thank you it worked

Brill star as always