topic Re: Script in QlikView

Script

mario-sarkis — Thu, 21 May 2015 12:02:33 GMT

Hey Guyz ,

I need Help here is my Question

i have a field for example

Renuwel Date

5/25/2015

4/31/2015

3/12/2015

i need to calculate the number of Renuwel Date > today

count(Renuwel Date)>today

How can i write this in a set analysis

Thank you,

Re: Script

robert_mika — Thu, 21 May 2015 12:29:08 GMT

=count({<[Renuwel Date] = {">$(=[Renuwel Date](today()))"} >}[Renuwel Date])

Re: Script

anbu1984 — Thu, 21 May 2015 12:31:44 GMT

Count(If(RenewalDate > Today(),1))

Re: Script

mario-sarkis — Thu, 21 May 2015 12:39:00 GMT

hi Robert i wrote it like this didn't work

count({<[KYC Renewal Date]={">$=Today()"}[KYC Renewal Date])

it didnt work where is my mistake ? can you help ?

Re: Script

prajapatiamar38 — Thu, 21 May 2015 12:47:12 GMT

Hi,

Try using this expression.

=Count({<[Renuwel Date]={">$(vA)"}>}[Renuwel Date])

Here vA is variable For Today's Date.

Re: Script

nagaiank — Thu, 21 May 2015 12:49:46 GMT

You may try this

Sum( If(RenewalDate > Today(), 1, 0) )

Re: Script

t_moutault — Thu, 21 May 2015 12:52:34 GMT

count({<[KYC Renewal Date]={">$=Today()"} >} [KYC Renewal Date])

Re: Script

anbu1984 — Thu, 21 May 2015 13:52:04 GMT

count({<[KYC Renewal Date]={">$(=Today())"> }[KYC Renewal Date])

Re: Script

robert_mika — Thu, 21 May 2015 13:54:45 GMT

Sorry my mistake:

=count({<[KYC Renewal Date] = {">$(=Date(today()))"} >}[KYC Renewal Date])

Re: Script

Anonymous — Thu, 21 May 2015 14:14:13 GMT

try this

=Count ({$< [Renuwel Date]= {">$(=Today())"}>}[Renuwel Date])

Re: Script

vijetas42 — Thu, 21 May 2015 14:15:53 GMT

Hi,

You can write expression as If(Renuwel Date>today,count(Renuwel Date))

Thanks!

Re: Script

cesaraccardi — Thu, 21 May 2015 16:28:50 GMT

Hi,

First you have to make sure the date field is being loaded correctly, you can use Date#() function to specify the date formatting that is coming from the data. Then on the expression a simple num(Today()) should work.

See image below,

Cesar

Re: Script

MarcoWedel — Fri, 22 May 2015 00:28:07 GMT

Hi,

another solution could be:

=-Sum([KYC Renewal Date]>Today())

Although the already suggested set expression

{$<[KYC Renewal Date]={">$(=Today())"}>}

should have the better performance.

hope this helps

regards

Marco