topic Re: Dynamically changing Text Object based on max values in QlikView

Dynamically changing Text Object based on max values

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Dynamically changing Text Object based on max values

vinieme12 — Thu, 19 Jan 2017 12:45:17 GMT

You want the text box to change to what exactly?

Re: Dynamically changing Text Object based on max values

Anonymous — Thu, 19 Jan 2017 12:51:45 GMT

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.

Re: Dynamically changing Text Object based on max values

Anonymous — Thu, 19 Jan 2017 13:32:21 GMT

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