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.

I have a Due date field in DD/MM/YYYY format.

I need to calculate the below measure

all items where duedate<= today and Status = completed in set analysis.

all items count(issuenum ) is there how to apply the above condition in set analysis.

Please help me on this.

Thanks in advance.

Nagaraju_KCS — Wed, 28 Mar 2018 06:51:01 GMT

Try

=Sum({<OrderDate={"<=$(=Date(Today(),'DD/MM/YYYY'))"}, Status={'Completed'}>}OrderSalesAmount)

jyothish8807 — Wed, 28 Mar 2018 06:55:04 GMT

Hi,

Try like this:

Count({<Duedate={"<=$(=date(today(),'DD/MM/YYYY')"},Status={'Completed'}>}issuenum )

bhavvibudagam — Wed, 28 Mar 2018 07:06:57 GMT

Hi Jyothish,

Thanks for your reply.

Could you please help me how to change the above expression for Max(Date) because In the source I haven't found today date.

bhavvibudagam — Wed, 28 Mar 2018 07:09:23 GMT

Hi Raju,

Thanks for your reply.

Could you please help me how to change the above expression for Max(Date) because In the source I haven't found today date.

Nagaraju_KCS — Wed, 28 Mar 2018 07:10:12 GMT

=Sum({<OrderDate={"<=$(=Max(OrderDate))"}, Status={'Completed'}>}OrderSalesAmount)

shiveshsingh — Wed, 28 Mar 2018 07:10:37 GMT

Count({<Duedate={"<=$(=date(Max(Date),'DD/MM/YYYY')"},Status={'Completed'}>}issuenum )

jyothish8807 — Wed, 28 Mar 2018 07:40:27 GMT

Count({<Duedate={"<=$(=date(Max(Date),'DD/MM/YYYY')"},Status={'Completed'}>}issuenum )

In the above case you have to be sure that you have two date fields 1. Duedate 2. Date

Count({<Duedate={"<=$(=date(Max(Duedate),'DD/MM/YYYY')"},Status={'Completed'}>}issuenum )

If i change the date to Duedate then it will not make any difference since all the duedate will be less that max(Duedate).

I believe there is something you are still missing wrt the requirement.

Br,