Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

mario-sarkis
Contributor

Script

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 Count of  [Renuwel Date] it is Greater than [Today()]

How can i write this in a set analysis

Thank you,

1 Solution

Accepted Solutions

Re: Script

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


BTW:

Duplicate


Script

7 Replies
datanibbler
Esteemed Contributor

Re: Script

Hi mario,

test this in a textbox on the GUI first. That way you can easily tell whether it works or not.

To do something like this, you need a way to compare this date with the output of the function > Today() <.

If it doesn't just work like that, the DATE#() function should help there - or you re-format your date in the script.

HTH

Re: Script

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


BTW:

Duplicate


Script

MVP
MVP

Re: Script

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

Re: Script

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

Robert_Mika

I understand this is a month old post, but I all seeing the highlighted part for the first time. Would you be able to share some information about it?

Thanks,

Sunny

Re: Script

Hi sunindia

Should have been:

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

See here:

Script

But Massimo (below) has even better option

MVP
MVP

Re: Script

Hi,

Try like below

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


Note: [Renuwel Date] and output of Today() should be in the same format.


Regards,

Jagan.

pratap6699
Contributor

Re: Script

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

Community Browser