topic Re: Go back one row per day in script in QlikView

Go back one row per day in script

cristianj23a — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys.

The goal is to back off the cessation one day before the registration date, I currently have that in set analisys, using the sentence below ().

But I would like to do this in script, without considering Sundays.

Please help me with this topic.

Greetings.

I attach the qvw.

jonathandienst — Thu, 01 Feb 2018 05:53:10 GMT

Not many people are going to download such a large sample. See here

ramasaisaksoft — Thu, 01 Feb 2018 11:14:22 GMT

upload the file without data and share sample data it will help us & you for getting fast replies.

Way 1:- Debug the script for some amount of data only

Way 2:- once you opened the application File tab-->Reduce Data-->Keep possible values/Remove all values will help you .

cristianj23a — Thu, 01 Feb 2018 14:57:25 GMT

Ready I reduced the data.

Attached the Qvw

regards.

cristianj23a — Thu, 01 Feb 2018 14:58:01 GMT

Ready