Dynamically changing Text Object based on max values

[Anonymous]

From the image attached below,

Inside the Top Trending technologies I have 4 text objects for Dotnet,Qlikview,Sharepoint,Dynamics CRM .

      For e.g. in the Dotnet text object, I have 2 text objects seperate for Image and for Count of Dotnet technolgy and the expression used is Count({<[Technology]={'Dotnet'}>}EmployeeID). I want the text objects to be changed dynamically based on the maximum count of technologies. Is it possible in text object and suggest me!

[vinieme12]

You want the text box to change to what exactly?

[Anonymous]

Based on the maximum values i want the text object to be changed (i.e) their position e.g now Dotnet is first but if anyother technologies count is more than Dotnet i want that technology in the first place.

[Anonymous]

You can do something like this. If you get the specific counter for each technology defined, Then you could use something like the below on a text box:

=if(SUM(DNCtr) > SUM(MSCtr),'qmem://<bundled>/BuiltIn/arrow_e.png','qmem://<bundled>/BuiltIn/arrow_s_r.png')

Change the textbox representation to image .

Hope this helps