Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
thx Alessandro
sorry, i means i want get the data as you explain, university name exactly.
but how?
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.
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
This is my example
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.
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
Dear Allessandro,
Thank you for your help
its worked.