topic Re: Drop Data in QlikView

Drop Data

tulsidaskhan — Fri, 05 Aug 2016 08:40:06 GMT

Hi,

After every reload a date is captured in a variable. can i drop data for this particular date by using drop statement.

Assumption: Something like " Drop table Abc where date<= variable"

Thanks,

Piyush Jain

Kushal_Chawda — Fri, 05 Aug 2016 09:02:47 GMT

How you are capturing the Date in variable?

Mark_Little — Fri, 05 Aug 2016 09:08:28 GMT

Hi,

You would need to do a resident load.

Load

Resident YourTable

Where Date > $(variable);

might need to think about the date formats,

Mark

jonathandienst — Fri, 05 Aug 2016 09:22:11 GMT

Like this:

If date <= variable Then

Drop table Abc;

End If

Make sure that the date and the variables are valid numeric date values.