How to format the formula

[kaushi2020]

I am using an expression to populate an id and a label from in the Pivot Table.

when I am selecting the value in it shows the formula(expression) behind that label.  Is there any way we can hide that to a generic term ? below is how the text is visible.

[udit_k]

write calculated dimension in script .

[Amy-M-Collins · Accepted solution]

Add your expression in the pivot table which you wish to filter for as a master item. 

Please see: https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-change-filter-label-in-qliksense/td-p/1548547 

[kaushi2020]

thanks for the solution, I tried to load as a column in my load editor. Not sure if that was a right approach.

[kaushi2020]

Hi there, I tried creating a master item, but when you select the dimension - it will show the formula behind it in the UI. I think the only way it can be done is via Load editor. 

when we select the value which is loaded via load editor - it will show only the label which we tried  calling via code.

[RafaelBarrios · Accepted solution]

hi @kaushi2020 

its always the best option to do it in script, but cant be done always.

so, you can try an AGGR() instead of using an IF statement

using IF

using AGGR to create a list on the fly

Hope this helps,

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button!