Check CrossTable for NULL Values

lylererger — Mon, 19 May 2014 13:39:22 GMT

Hi !

I'm trying to get the simple table from CrossTable. Source document - Excel, at each Tab single crosstable. Name of Tab in format "YYYYMM".

I've got the weight coefficients on every tab by dates of outlets. If the data exists all is OK. If i there is no eny weights - CrossTable doesn't works. But i need the key information on the tabs which not includes any weights - it's the list of dates and outlets.

I'm trying to use NULLASVALUE with SET of null variable, but it doesn't yield any result...

Some peace of code:

LET vFezPrev = 201301;
LET vFezCur = 201412;

IF Alt(FileSize('$(vFile)'),0)>0 then

  FOR vFez = vFezPrev to vFezCur

  LET ErrorMode=0;

  CALL DropTables('tmpData');

  tmpData:
  CrossTable(Date, Weight, 3)
  LOAD 
  *
  FROM
  [$(vFile)]
  (ooxml, embedded labels, table is [$(vFez)]);

  LET vtmpFile = '$(vPathXLSDest)\$(vPrefixXLS2)_$(vFez).qvd';

  EXECUTE cmd.exe /C del /Q $(vtmpFile);

  STORE tmpData INTO [$(vtmpFile)](qvd);

  LET ErrorMode=1;

  NEXT

  ELSE

  TRACE NO DATA;

  ENDIF

Hope for yours help.

Thnx.

Re: Check CrossTable for NULL Values

marcus_sommer — Mon, 19 May 2014 14:10:24 GMT

Within a crosstable-load you couldn't really check and/or change any data. Therefore make at first a ordinary load and use crosstable as second step.

- Marcus

topic Re: Check CrossTable for NULL Values in QlikView

Check CrossTable for NULL Values

Re: Check CrossTable for NULL Values