Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hi,
i cant understand, you want to write SQL code in qlikview pivot table expression?
Regards,
P.Prasath
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)))