topic Re: date() in QlikView

date()

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

Hi Experts,

Can any one please help me on below requirement.

In this sheet when I have filtered Duedate i.e., 01/23/2017 then its qualifying 01/23/2017-01/29/2017 in the top left KPI

I have to filter the dates 01/23/2017,01/24/2017,01/25/2017,01/26/2017....01/29/2017 in the below table box based on Due Date Dimension.

Here filter dimension and table dimension both are same

In that kpi i have used this expression

=Date(WeekStart(Max(DueDate),0,0),'MM/DD/YYYY') & =Date(Weekend(Max(DueDate),0,0),'MM/DD/YYYY')

Re: date()

clovati — Thu, 29 Mar 2018 10:32:14 GMT

Hi!

It would be easier if you create in your loading script in Calendar table, for each day, two more fields: beginning of the week and end of the week.

Then your set analysis will work with these two fields (more performance).

Ciao

Cri

Re: date()

bhavvibudagam — Thu, 29 Mar 2018 10:38:42 GMT

Hi,

Actually I am just looking to apply the condition on Due date field dimension.

When I have filtered 01/18/2017 from due date field then only

01/16/2017 - 01/22/2017 i.e.,

01/16/2017,01/17/2017,01/18,2017....01/22/2017 these dates need to filter on table box.

Re: date()

clovati — Thu, 29 Mar 2018 10:43:02 GMT

Set analysi works better not onexpression but on fields (if you can).If your dates are in loading, you can build the dates. You always and for ever know what are days begininng and end of the week.

Re: date()

Anonymous — Thu, 29 Mar 2018 12:45:04 GMT

Hi Bhavani,

I didn't get you, what you are asking ?

But seeing the charts & selections i can understand as

Inside the expression they are written condition as , based on the data selection it will show the selected week(Starting of week to end of week) totals.

Are you don't want to represent entire week totals ?, Can you explain bit elaborate.

Thanks,

Venkata Sreekanth