Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

joaquinlr
Valued Contributor II

CrossTable question

Hello guys:

I have this CrossTable and it works as expected

File:

CrossTable(LINE, DESCRIPCION, 1)

LOAD CODAR, 

     DESC01, DESC02, DESC03, DESC04, DESC05, DESC06, DESC07, DESC08, DESC09, DESC10;

Some of the fields DESC* could have no value

Is there any way to create a CrossTable without the null or empty items ?

Well, I would do it using two steps, but if there is an easy way, it will be a faster script.

Thanks for your support.

Joaquín

1 Reply

Re: CrossTable question

Like you said, I usually do it in the next resident load and not sure if there is another way.

Community Browser