Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Need to be more precise but,
WHERE col3 ='' OR col3 is NULL
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.
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.
if (condition) then
drop column col3
end if
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.
if FieldValueCount('col3') = 1 then
drop field col3;
end if
thx it resolves my problem 😉