Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

sujit_nath
Contributor

Change Data at front-end in Qlikview dashboard

I have a dashboard, where in a list box, I have data as :

Header 1
ABC-CDE-XYZ
XYZ-ABC
XYZ-PMO-PQR-ABC

     


I have a requirement as in front end, I need to change text
ABC to TEXT2.

How this can be done without refreshing the data or changing the data at all? Change is only in the text that's appearing here.

Thanks.

1 Solution

Accepted Solutions
Frank_Hartmann
Honored Contributor

Re: Change Data at front-end in Qlikview dashboard

go to listbox settings on General Tab and open treelist for Field and scroll down to the bottom and insert the formula under Expression!

Unbenannt.png

4 Replies
MVP
MVP

Re: Change Data at front-end in Qlikview dashboard

This?

Replace([Header 1], 'ABC', 'TEXT2')

Highlighted
sujit_nath
Contributor

Re: Change Data at front-end in Qlikview dashboard

Thanks, But When I apply this in expressions, I see old value as well as new value. I want to override the old value.

It will be helpful if you can guide me where do I apply this logic.

Thanks for the help!

Frank_Hartmann
Honored Contributor

Re: Change Data at front-end in Qlikview dashboard

go to listbox settings on General Tab and open treelist for Field and scroll down to the bottom and insert the formula under Expression!

Unbenannt.png

sujit_nath
Contributor

Re: Change Data at front-end in Qlikview dashboard

Great!! This works exactly as expected for me. Thanks a lot Frank and Tresesco!