topic invalid expression in QlikView

invalid expression

Wed, 26 Nov 2014 15:31:22 GMT

Hi,

I am getting this error.

Invalid expression

Concatenate (BIOGraph)

Load UID,

'Baselined' as Category,

if( [BaselineSaveDate] > '1998/09/09' ,1,0) as value,

if( [BaselineSaveDate] > '1998/09/09',count(UID))/count(UID) as PercentValue

Resident ProjectTracker

what is the issue?

Thanks

Re: invalid expression

rubenmarin — Wed, 26 Nov 2014 15:40:37 GMT

Hi Amit, you are using count() without a Group by, try something like:

Concatenate (BIOGraph)

Load UID,

'Baselined' as Category,

if( [BaselineSaveDate] > '1998/09/09' ,1,0) as value,

if( [BaselineSaveDate] > '1998/09/09',count(UID))/count(UID) as PercentValue

Resident ProjectTracker

Group by UID, [BaselineSaveDate];

Re: invalid expression

Wed, 26 Nov 2014 19:56:16 GMT

Hi Ruben,

Thanks a lot.