topic Re: Creating a Model in QlikView

Creating a Model

ganeshreddy — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have data as shown below

and i need to show like below,

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

Re: Creating a Model

pradosh_thakur — Wed, 30 Jan 2019 09:09:49 GMT

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;

Re: Creating a Model

anushree1 — Wed, 30 Jan 2019 09:17:44 GMT

Please check the attached

Re: Creating a Model

anushree1 — Wed, 30 Jan 2019 09:18:18 GMT

sorry missed attchment

Re: Creating a Model

anushree1 — Wed, 30 Jan 2019 09:28:56 GMT

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

Re: Creating a Model

its_anandrjs — Wed, 30 Jan 2019 11:03:10 GMT

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;

Regards

Anand