Problem with Sql code...please help

[#1]

Hello everyone,

I have a problem with the following SQL code that must be inserted into my pivot table expression:

select count(ClaimId)

FROM

(SELECT CLaimId

FROM Dauna 

WHERE DataRaportare <= '20111231'

GROUP BY CLaimId

HAVING SUM(RezervaRamasa) != 0

I have tried to use "aggr" function and set analysis, but the result is wrong...

Please help me with this.

Best regards,

Silviu.

[#2]

hi,

i cant understand, you want to write SQL code in qlikview pivot table expression?

Regards,

P.Prasath

[#3]

Hello,

The problem is transforming this sql code into expression code...

Something like:

Count( if( aggr(

DataRaportare <= '20111231'

and...

, CLaimId, CLaimId if(SUM(RezervaRamasa) != 0)))