Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
vishalgoud
Creator III
Creator III

how to make an another table summary as a new value to the dimension..??

All,

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

---------------   --------------

Muthurajan    50

Contract         78

Akshay            90

is it possible to create a insert a new value into a dimension table..

??

1 Reply
felipedl
Partner
Partner

Hi Vishal,

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).

Mapping

GP_Name:

load * Inline

[

Id,Description

1,Muthurajan

2,Akshay

];

Permanent:

load

*,

ApplyMap('GP_Name',GP_Id,'Contract') as Mapped_field;

load * Inline

[

Id,Name_P,GP_Id

1,AAAA,1

2,BBBB,1

3,CCCC,2

4,DDDD,

];

NoConcatenate

Contract:

load

*,

ApplyMap('GP_Name',GP_Id,'Contract') as Mapped_field;

Load * Inline

[

Id,Name_C,GP_Id

1,xxxx,

2,yyyy,

];

As a result, I get this:

sample.png