Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
Showing results for 
Search instead for 
Did you mean: 
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
Champion II
Champion II

You want the text box to change to what exactly?

Contributor II
Contributor II

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.

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