Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

CROSS TAB ISSUE - MISSING VALUES

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,

Tags (3)
4 Replies
Highlighted
Not applicable

Re: CROSS TAB ISSUE - MISSING VALUES

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.

Highlighted
Not applicable

Re: CROSS TAB ISSUE - MISSING VALUES

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,

Highlighted
MVP & Luminary
MVP & Luminary

Re: CROSS TAB ISSUE - MISSING VALUES


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.

Highlighted
Not applicable

Re: CROSS TAB ISSUE - MISSING VALUES

Thanks Jagan, it is working fine, but let me check my dev data first and come  back to you. Thanks,