topic Linking through objects in QlikView

Linking through objects

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

Hi All,

Can we link from one object to other?

Suppose I have a straight table having columns 1.Standard 2. PASS 3. FAIL

Standard	PASS	FAIL
1	20	30
2	30	20
3	25	25
4	50	0
5	24	26
6	40	10

If I click on 20 in PASS for standard 1 it should open another straight box below that to show details of those 20 students.

FirstName, LastName, Gender, Maths, Physics, History

Now if I click on any other value for any standard then opened straight table should be hidden and new table with detailed information should be opened.

How to achieve this?

Regards

Re: Linking through objects

Anil_Babu_Samineni — Fri, 07 Oct 2016 16:41:41 GMT

Hey, If you are expecting from Table Box. I hope this shouldn't work

Instead of that try AdHoc Reports

https://community.qlik.com/docs/DOC-5404

Re: Linking through objects

Anonymous — Fri, 07 Oct 2016 17:07:19 GMT

Its not possible from table box, properties also very limited on Table Box.

By using Triggers and AdHoc reporting you can sort it, try on straight tables for best practices.

Refferences:

Conditional Show based on Chart Selection

http://livingqlikview.blogspot.in/‌

Re: Linking through objects

Anonymous — Fri, 07 Oct 2016 17:12:45 GMT

You could use

getposiblecount(Standard)

If you select a single value for Standard it will return the count as 1.

Thus you could use it for show/hide conditions on your tables.

Re: Linking through objects

nachiket_shinde — Mon, 10 Oct 2016 12:12:02 GMT

Can we do it on Straight table?

Re: Linking through objects

nachiket_shinde — Fri, 14 Oct 2016 09:46:09 GMT

Can we do it on Straight table?