Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Problem with Sql code...please help

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 Replies
Not applicable

Problem with Sql code...please help

hi,

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

Regards,

P.Prasath

Not applicable

Problem with Sql code...please help

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

Community Browser