topic Re: Script in QlikView

Script

mario-sarkis — Thu, 21 May 2015 12:19:44 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 Count of [Renuwel Date] it is Greater than [Today()]

How can i write this in a set analysis

Thank you,

Re: Script

datanibbler — Thu, 21 May 2015 12:31:08 GMT

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

robert_mika — Thu, 21 May 2015 12:35:25 GMT

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

BTW:

Duplicate

Script

Re: Script

maxgro — Wed, 01 Jul 2015 21:36:02 GMT

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

Re: Script

sunny_talwar — Wed, 01 Jul 2015 23:20:44 GMT

=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

robert_mika — Thu, 02 Jul 2015 05:31:31 GMT

Hi sunindia

Should have been:

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

See here:

Script

But Massimo (below) has even better option

Re: Script

jagan — Thu, 02 Jul 2015 05:51:34 GMT

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.

Re: Script

pratap6699 — Thu, 02 Jul 2015 07:51:19 GMT

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