topic Problem with Sql code...please help in QlikView

Problem with Sql code...please help

Thu, 26 Apr 2012 07:45:32 GMT

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.

Thu, 26 Apr 2012 08:07:10 GMT

hi,

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

Regards,

P.Prasath

Thu, 26 Apr 2012 08:11:50 GMT

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)))