Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Pragya
Creator
Creator

Edit the dynamic field in Qlik Sense

Hi All,

I am working on a Qlik Sense App Development and working on dynamic fields on Dashboard.

Now my field name was EventNumber but its alignment was on the right side.

So to correct the alignment I put =Text(EventNumber ).

But now the problem is when I do the dynamic selection by

= text([Event Number])

it shows '= text([Trauma Event Number])' but in the dashboard I want to see just EventNumber and not = text([Trauma Event Number]).

Can anyone help.

Thanks beforehand 🙂

6 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You will need to add an aggr() like:

Aggr(only(text([Event Number])), [Event Number])

See: https://qlikviewcookbook.com/2016/01/scoping-selections-with-aggr/

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Pragya
Creator
Creator
Author

Thankyou But it didn't work 😞

Vegar
MVP
MVP

Which version of Qlik Sense are you working on? This is become better in the later release.

A workaround is to create the dimension in the script.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I typed it quick and forgot the only.  I've updated the answer to include only() and the mossing paren.  Please do read the blog post as well. 

-Rob

Pragya
Creator
Creator
Author

Desktop free version
Pragya
Creator
Creator
Author

Still not working. Can we edit (bold , align) the text or footnote or title in desktop free version?