Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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?