topic dynamic sql loading in QlikView

dynamic sql loading

Thu, 02 Dec 2010 19:24:58 GMT

hi,

i search to do a dynamic loading a table

for example

mytable:

col1, col2,col3

if data in col3 is empty

i want see in qlikview just data in col1 and col2

SV:dynamic sql loading

Fri, 03 Dec 2010 08:38:51 GMT

Need to be more precise but,

WHERE col3 ='' OR col3 is NULL

dynamic sql loading

Fri, 03 Dec 2010 09:31:25 GMT

Hi.

Don't understend what is your problem, if u dont want show col3, just dont show it in qlikview. You cal load all table, an the just show what you want.

dynamic sql loading

Fri, 03 Dec 2010 09:48:03 GMT

col3 can have data or not ,i dont know before the loading. Anyway i use col3 in my QV application like criteria. And if i load col3, with null data, my criteria will be null:/. So if i dont load col3 my criteria willn't appear in my QV application.

dynamic sql loading

Fri, 03 Dec 2010 10:18:13 GMT

if (condition) then

drop column col3

end if

dynamic sql loading

Fri, 03 Dec 2010 10:51:26 GMT

i try that

if (col3 = null) then

drop column col3;

End if

but that doesn't work currently, i do a qvw example.

thx for your help.

dynamic sql loading

Fri, 03 Dec 2010 12:20:33 GMT

if FieldValueCount('col3') = 1 then

drop field col3;

end if

dynamic sql loading

Fri, 03 Dec 2010 14:24:26 GMT

thx it resolves my problem 😉