Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
ganeshreddy
Creator III
Creator III

Creating a Model

Hi All,

I have data as shown below

.BT.PNG

and i need to show like below,

BT1.PNG

 

Please suggest a way to create separate data set in the model or suggest a way to represent as required. PFA example data

Thanks,

Ganesh 

5 Replies
pradosh_thakur
Master II
Master II

table1:
load * Inline [
Skey,PSKey,Profit
222,111,1000
555,444,300
111,,600
777,666,300
444,,200
999,888,1000
666,,500
888,,500
333,,800
];

left join
load Skey as PSKey,
Profit as PProfit

resident table1;
Learning never stops.
anushree1
Specialist II
Specialist II

Please check the attached

anushree1
Specialist II
Specialist II

sorry missed attchment

anushree1
Specialist II
Specialist II

Code used:

Temp:

LOAD distinct PSkey as Required
FROM
Data\PSKEY.xlsx
(ooxml, embedded labels, table is Sheet1);

Final:
Directory;
LOAD Skey,
PSkey,
Proft
FROM
Data\PSKEY.xlsx
(ooxml, embedded labels, table is Sheet1)
Where Exists(Required,PSkey);


drop table Temp;

 

OUTPUT:

Skey PSkey Proft
222 111 1000
555 444 300
777 666 300
999 888 1000

its_anandrjs

Hi,

Try to load your table this ways

Hope this helps.

Data:
LOAD Skey,
            PSkey, 
            Proft
FROM
[E:\C\Source\Test.xlsx]
(ooxml, embedded labels, table is Sheet1);

Inner Join(Data)
New:
LOAD Skey as PSkey,
            Proft as PProft
Resident Data
Where Len(PSkey) = 0;

1.JPG

 

Regards

Anand