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

its_anandrjs — Wed, 30 Jan 2019 11:00:38 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

Re: Creating a Model

pasi_lehtinen — Wed, 30 Jan 2019 12:04:48 GMT

Initial:
Load * Inline [
Skey, PSkey, Proft
222,111,1000
555,444,300
111,,600
777,666,300
444,,200
999,888,1000
666,,500
888,,500
333,,800
];

Final:
NoConcatenate Load 
	Skey, 
    PSkey, 
    Proft as Profit
Resident Initial where len(PSkey)>0; 

left join(Final)
Load 
	Skey as PSkey,
    Proft as PProfit
Resident Initial
where len(PSkey)=0;

vKeys_tmp:
Load chr(39)&Concat(PSkey,chr(39)&','&chr(39))&chr(39) as vPSkey Resident Initial
where len(PSkey)>0;
Let vPSkeys = peek('vPSkey',0,'vKeys_tmp');

Concatenate(Final)
Load
	Skey,
    null() as PSkey,
    Proft as Profit,
    null() as PProfit
Resident Initial
where len(PSkey)=0 and not match(Skey,$(vPSkeys));

drop table vKeys_tmp;
drop table Initial;