topic Re: How to format the formula in App Development

How to format the formula

Kaushik2020 — Thu, 13 Jul 2023 07:00:44 GMT

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.

Re: How to format the formula

udit_k — Thu, 13 Jul 2023 08:34:50 GMT

write calculated dimension in script .

Re: How to format the formula

Amy-M-Collins — Thu, 13 Jul 2023 08:41:05 GMT

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

Re: How to format the formula

Kaushik2020 — Thu, 13 Jul 2023 09:08:36 GMT

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

Re: How to format the formula

Kaushik2020 — Thu, 13 Jul 2023 09:32:25 GMT

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.

Re: How to format the formula

RafaelBarrios — Thu, 13 Jul 2023 18:36:58 GMT

hi @Kaushik2020

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!