topic Re: Master - Detail Pivot table in QlikView

Master - Detail Pivot table

Tue, 14 Jul 2015 07:33:52 GMT

Hai All,

How are you?

I am new comer in qlikview, i wold like to catch return value from selected pivot table, and then use it for other pivot table as detail data.

simple example, we have list of university in 1 pivot table, and then other pivot table exist of college student. so when we choose 1 unitversity then 2nd pivot table will show all of college student at university that choosed.

any body can help me?

thx b4.

Re: Master - Detail Pivot table

alexandros17 — Tue, 14 Jul 2015 07:37:26 GMT

Tables in the layout are not accessible from other tables, only Data can be shared through the Whole document, so if you need some data in 2 different pivot the better choice is to compute in the script the use them where you want.

Hope this helps

Re: Master - Detail Pivot table

Tue, 14 Jul 2015 07:43:31 GMT

thx Alessandro
sorry, i means i want get the data as you explain, university name exactly.

but how?

Re: Master - Detail Pivot table

alexandros17 — Tue, 14 Jul 2015 07:46:53 GMT

If data are linked then you need a list box (or a multibox) for university then a straight table (or pivot) for student but I should see data to tell you how to do.

Re: Master - Detail Pivot table

Tue, 14 Jul 2015 07:53:50 GMT

herewith simple ilustration, there are 2 pivot table :

pivot 1st,

University:

[university name],Major, Adress, TotalCollegeStudent, [etc..]

pivot 2nd,

CollegeStudent:

[university name], Major, [CollegeStudent Name], [Date entring], [etc..]

when we click one of university in 1st pivot, then show all college student at those university in 2nd pivot.

hopefully can make clear the question.

thx

Re: Master - Detail Pivot table

alexandros17 — Tue, 14 Jul 2015 08:06:17 GMT

This is my example

Re: Master - Detail Pivot table

Tue, 14 Jul 2015 08:12:29 GMT

Dear Alessandro,

verry sory because my qlikview is desktop version,

so i cant open this file.

dio you have other ide to explain end describe to me

thank you.

Re: Master - Detail Pivot table

alexandros17 — Tue, 14 Jul 2015 08:20:04 GMT

This is an example of your data ...

University:
LOAD * Inline [
university name,Major, Adress, TotalCollegeStudent
NY,Sam,Street 1,5000
Boston,John, Street2,3500
LA,Bob,Street3,4600
London,David, Street4,7000
Paris,Mike, Street5,12000
];

CollegeStudent:
LOAD * Inline [
university name, CollegeStudentName, Date entring
NY,student1,
NY,student2,
NY,student3,
Boston,student4,
LA,student5,
LA,student6,
LA,student7,
LA,student8,
LA,student9,
London,student10,
London,student11,
Paris,student12,
];

then create 2 pivot tables the first with:

dimension: university name, major, address

expression: sum(totalcollegestudent)

the second pivot with

dimension: university name, collegestudentname

expression: sum(totalcollegestudent)

let me know

Re: Master - Detail Pivot table

Tue, 14 Jul 2015 08:30:33 GMT

Dear Allessandro,

Thank you for your help

its worked.