Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Extension object dropdown menu in sheet

Hi

Does anyone have an extension object that create a Dropdown Menu that for example could be used to display customers name or similar.

I have found dropdown menus for the tab menu, but it doesn't work for me.

Kind regards

Espen

5 Replies
Alexander_Thor
Employee
Employee

I can't think of one from top of my head.

But do you care to elaborate a little bit on the use case? I'm guessing you are looking for something similar to a listbox but with dropdown capabilities?

The multi-box could work as a poor-mans dropdown if you need a quick fix.

Not applicable
Author

Thanks for the answer. I've been thinking about the same, guess that is the way to go.

Rgds

Espen

Not applicable
Author

The problem with the dropdown extension from Petra Bloem is that it does not keep the parent sheet highlighted in the navigation bar once it is clicked (or one of its sub-items is clicked). Does anyone know how to solve this?

Regards,

MS

Anonymous
Not applicable
Author

Hi Miguel,

I have found a solution, not the best, but it's working:

Replace the lines:

if (isLink) {

  tabelem.innerHTML = '<a href="javascript:;">'+sheetTitle+'</a>';

  } else {

  tabelem.innerHTML = "<span>" +sheetTitle + "</span>";

  }

by these lines:

var TypeTitle = "";

  var linkTitle = "";

  if (isLink) {

  linkTitle = ' href="javascript:location.reload()"';//location.reload();"';

  TypeTitle = 'a';

  } else {

  linkTitle = "";

  TypeTitle = 'span';

  }

  var shifted = false;

  if(!shifted)

  {

  $('.QvFrame').each(function(){

  var lesClasses=$(this).attr('class');

  var SheetName = "QvFrame Document_" + sheetTitle;

  if (lesClasses == SheetName)

  {

  TypeTitle = 'cur';

  }

  });

  shifted = true;

  }

  

  tabelem.innerHTML = '<'+TypeTitle+linkTitle+'>'+sheetTitle+'</'+TypeTitle+'>';

Next, create on the css file new style 'cur'.

You can copy style 'a' and change the color.

A last thinks to do, is to create on each sheet an text object, withe the Id='name of the sheet'.

(I have not find the code to load the sheetname)