Discussion Board for collaboration related to QlikView App Development.
Have permanent students details in table A and contract based students details in table B.
Both students oyees swipe in information is available in table C.
Now we want to show the entire contract based students count as one of the value in a pivot table. where we have to use one of the dimension from table A.
its like GP name is a dimension from the table A and contract is the new dimension value that we are expecting under the GP Name...
is it possible... ??
All tables like A , B and C are connected with Student ID as a common key..
its like below...
GP Name Count
is it possible to create a insert a new value into a dimension table..
Since I don't know the table's structure, i created something quite simple.
Basically what I did was to map a GP_Name into both tables (Table Permanet is your A table where the field already exists, Contract is the created one).
load * Inline
ApplyMap('GP_Name',GP_Id,'Contract') as Mapped_field;
Load * Inline
As a result, I get this: