This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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
Please check the attached
sorry missed attchment
LOAD distinct PSkey as RequiredFROMData\PSKEY.xlsx(ooxml, embedded labels, table is Sheet1);
Final:Directory;LOAD Skey,PSkey,ProftFROMData\PSKEY.xlsx(ooxml, embedded labels, table is Sheet1)Where Exists(Required,PSkey);
drop table Temp;
Skey PSkey Proft222 111 1000555 444 300777 666 300999 888 1000
Try to load your table this ways
Hope this helps.
Data:LOAD Skey, PSkey, ProftFROM[E:\C\Source\Test.xlsx](ooxml, embedded labels, table is Sheet1);
Inner Join(Data)New:LOAD Skey as PSkey, Proft as PProftResident DataWhere Len(PSkey) = 0;