Qlik Community

QlikView Extensions

Discussion Board for collaboration on QlikView Extensions.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Employee
Employee

Re: Extension object dropdown menu in sheet

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

Re: Extension object dropdown menu in sheet

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

Rgds

Espen

cjzimm76
Contributor

Re: Extension object dropdown menu in sheet

Not applicable

Re: Extension object dropdown menu in sheet

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

alexdp19
New Contributor II

Re: Extension object dropdown menu in sheet

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)