Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist II
Specialist 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
Highlighted

Re: CrossTable question

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