topic Re: How to link to table in QlikView

How to link to table

Thu, 05 Dec 2013 23:47:22 GMT

Based on selection table pop's up.In that table need to give link to open other feilds.

Need to give link to give other fields .. part number , part desription ,score etc

Re: How to link to table

stevedark — Thu, 05 Dec 2013 23:58:13 GMT

If I understand what you are asking correctly, what you require is conditional show conditions on a number of different multiboxes to show a different multibox dependent on the selection in a field.

In the properties of the Multiboxes you should go to the Layout tab and select the Conditional radio button. In the Conditional box type this expression:

=Only([Commodity Code Description]) = 'DO NOT USE'

This will show that list of selections only when DO NOT USE is selected. You will want to have other multiboxes showing on other selected values, I guess. You can then have another box which shows when there is more than one possible value in that field, the Conditional code for this one will be:

=GetPossibleCount([Commodity Code Description]) <> 1

Hope that I have understood your requirements correctly and that this helps point you in the right direction.

- Steve

Re: How to link to table

Fri, 06 Dec 2013 00:05:39 GMT

Thank again .I got this part.

My requirement is i need to show other fieelds related to that table when i select link to expand Need to pop up those feilds for that particular supplier..

Please find the screen shot

Re: How to link to table

Fri, 06 Dec 2013 00:08:27 GMT

I should give the link to open the table with part number and part description.. hope you understood now.

Thanks in advance

Re: How to link to table

stevedark — Fri, 06 Dec 2013 00:22:39 GMT

The nature of QlikView is that on any selection everything else flexes to only show related information.

The table you show there is not a 'out of the box' type display in QlikView. I think the best way to achieve it will be to create a chart with Customer as the only dimension. You will then need to create an expression for each row of your table, eg: Supplier Score would be =max([Supplier Score]) and EW Status would be =maxstring([EW Status]).

For each expression make sure that the Total Mode is set to No Totals.

On the Presentation tab of the Properties tick the Horizontal check box. This should put customers along the top and your expressions down the left.

This will only work if all the values in the columns only exist in your table once per customer.

If you have lots of customers in the table you may want to put a Calculation Condition on the table - so it does not get too wide. Just set the Calculation Condition on the General tab to be something like:

=GetPossibleCount(Customer) <= 20

Hope that helps,

Steve

Re: How to link to table

Fri, 06 Dec 2013 04:55:00 GMT

i need to link to a field values (part number, part description,commodity etc)

Re: How to link to table

stevedark — Fri, 06 Dec 2013 09:08:47 GMT

I'm sorry - what do you mean by 'link to'? Are you wanting to add a web link to something external to the document?

Steve

Re: How to link to table

Fri, 06 Dec 2013 16:56:14 GMT

Hyperlink to new object , when they select the field value.

Re: How to link to table

stevedark — Sat, 07 Dec 2013 10:43:15 GMT

Where is the new object? Is it an item on the a sheet in this QlikView document, another QlikView document or on a website? What type of object is it?