Discussion Board for collaboration on QlikView Scripting.
I have this CrossTable and it works as expected
CrossTable(LINE, DESCRIPCION, 1)
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.
Like you said, I usually do it in the next resident load and not sure if there is another way.