Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Team,
how to load attached excel data in qlikview?
description are same for some entries ,suppose if i select asd for jan month total displaying 2,
Something like this...
Data:
CrossTable(Month, Data)
LOAD F1,
[42005.000000],
[42036.000000],
[42064.000000]
FROM
test123.xlsx
(ooxml, embedded labels, table is Sheet2, filters(
Remove(Row, RowCnd(CellValue, 1, StrCnd(contain, 'Revenue')))
));
Final:
Load F1 as Name, Date(SubField(Month,'.',1),'MMM-YY') as MonthYear, Num(Data) as Data Resident Data
Where Len(Trim(Data)) <> 0;
Drop Table Data;