Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
nithya123
Contributor II
Contributor II

Dynamically changing Text Object based on max values

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!

3 Replies
vinieme12
Champion II
Champion II

You want the text box to change to what exactly?

nithya123
Contributor II
Contributor II
Author

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.

imadzidan
Contributor III
Contributor III

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