Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a problem with the following SQL code that must be inserted into my pivot table expression:
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.
i cant understand, you want to write SQL code in qlikview pivot table expression?
The problem is transforming this sql code into expression code...
Count( if( aggr(
DataRaportare <= '20111231'
, CLaimId, CLaimId if(SUM(RezervaRamasa) != 0)))