Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am working on personal edition. When I do Cross tab I am missing few blank records. "What to do Not to avoid blank records". Attached sheet contains examples When I pull RunDate list box in the dashboard, I am getting from 1 to 8 dates data and I am missing rest of the records which is having blanks from 9 to 12th dates
my script is
CrossTable(Mths, Data, 5)
LOAD RunDate,
A1,
A2,
A3,
A4,
Jan,
Feb,
Mar,
Apr,
May,
Total
FROM
(ooxml, embedded labels, table is Sheet1);
Please find the attached source file,screen shot from the Qlikview and let me know what is missing here??
Thanks,
Hi,
I tried to pull the data from your above excel and used applied crosstable. The date value in list box appeared as you expected.
Try to load the data again and check the data in FileWizard whether the data is showing with all the records or not.
I supposed to get all the RunDates without missing any dates. My list box missing 9/9/2013 10/10/2013 11/11/2013 12/12/2013 Why its happening like this?? I tried to load again and got the same results. Thanks,
Hi,
Try this script
Directory
;
CrossTable
(Mths
, Data
, 5)
LOAD
Date
(RunDate
) AS
RunDate
,
A1
,
A2
,
A3
,
A4
,
Jan
,
Feb
,
Mar
,
Apr
,
May
,
Total
FROM
[Cross tab test.xlsx]
(ooxml
, embedded
labels
, table
is
Sheet1, filters
(
Replace
(1, top
, StrCnd
(null
))
));
Regards,
Jagan.
Thanks Jagan, it is working fine, but let me check my dev data first and come back to you. Thanks,