topic Re: set analysis in QlikView

set analysis

mario-sarkis — Thu, 04 Jun 2015 06:14:08 GMT

hey all hope you can help my problem is the following:

Renewal Date type is number i need to count the Renewal Date > today() and ofcaurse i dont want to count the empty field

Count( {<Renewal Date > today()>}Renewal Date)

how can i wirte it in a correct way please help,

Anonymous — Thu, 04 Jun 2015 06:20:16 GMT

first you need to load your date column as date

Date(]Renewal Date]) as [Renewal Date]

then

if (len([Renewal Date] )>0,count({<[Renewal Date]>={Today(0)}>}[Renewal Date]))

Thanks

BKC

PrashantSangle — Thu, 04 Jun 2015 06:29:34 GMT

Hi,

try below

Count( {<[Renewal Date] ={">(=today())"}>}Renewal Date)

Note: carefull with date format

Regards

PrashantSangle — Thu, 04 Jun 2015 06:30:52 GMT

Hi,

USe distinct if you need distinct Count

Count( {<[Renewal Date] ={">(=today())"}>}DISTINCT [Renewal Date])

Regards

prajapatiamar38 — Thu, 04 Jun 2015 06:33:47 GMT

Hi..

Please find the attached qvw below.

Hope this will help you.

Thanks