Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

dynamic sql loading

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

7 Replies
Not applicable
Author

Need to be more precise but,

WHERE col3 ='' OR col3 is NULL


Not applicable
Author

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.

Not applicable
Author

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.

Not applicable
Author

if (condition) then

drop column col3

end if

Not applicable
Author

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.

Not applicable
Author

if FieldValueCount('col3') = 1 then

drop field col3;

end if

Not applicable
Author

thx it resolves my problem 😉