topic Re: specific day in QlikView

specific day

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

Hi all,

I want to load the data from database only Saturday's data

how can I load this?

can anyone give the syntax of it?

its_anandrjs — Thu, 14 Sep 2017 06:42:46 GMT

If you have any date field then try this

Load

From Source where WeekDay(DateField) = 'Sat';

Anil_Babu_Samineni — Thu, 14 Sep 2017 06:43:31 GMT

These?

Load * From Table Where Match(WeekDay(FieldName), 'Sat');

Load * From Table Where WeekDay(FieldName) = 'Sat';

Load * From Table Where WeekDay(FieldName) Like 'Sat';

its_anandrjs — Thu, 14 Sep 2017 06:45:50 GMT

Another way also on UI you can do this if you have day field

Sum( {<Dayfield = {'Sat'} >} Sales)

soniasweety — Thu, 14 Sep 2017 06:49:12 GMT

I have a weeknumber column in DB and I want to load last 10 weeks data of Saturday's ?

is it possible?

its_anandrjs — Thu, 14 Sep 2017 06:50:11 GMT

What type of data it has num or string.

soniasweety — Thu, 14 Sep 2017 06:51:32 GMT

Numbers only

weeknumber

32 like that

its_anandrjs — Thu, 14 Sep 2017 06:56:04 GMT

Try this with where condition

Table1:

Load

From Source Where WeekDay(DateField) >= Max(weeknumber) - 10 and WeekDay(DateField) <= Max(weeknumber);

soniasweety — Thu, 14 Sep 2017 07:01:29 GMT

Okay Anand thanks I will try and update on the same