Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
ce_gutierrez
Contributor III
Contributor III

AGGR on Qliksense

Dear Friends,

I'm trying to make a table or pivot table on Qliksense using this expression but it doesn't work. I'm using this expression on Qlikview and works propertly. Maybe is not allowed this kind of expressions.

Thanks for your help

BEst Regards

IF(AGGR(SUM({<TIPO_METRICA={'ING'}>}Monto),RAZON_SOCIAL)>=vMinimaFacturación and

   AGGR(SUM({<TIPO_METRICA={'ING'}>}Monto),RAZON_SOCIAL)<=vMaximaFacturacion,

   SUM({<TIPO_METRICA={'ING'}>}Monto))

3 Replies
sunny_talwar

Have you made sure that your two variables are present and show the same value?

ToniKautto
Employee
Employee

The aggregation is expected to work the same way in Qlik Sense as in QlikView. In addition to stalwar1 comment about the variable value, the difference can also come from different selections or the data.

For clarity it would be great if you can elaborate on what result you actually see, as "it doesn't work" is a very vague symptom definition. If possible a QVW and QVF file would make it a lot easier to analyse what you are doing differently in QlikView and Qlik Sense.

robert_mika

Maybe:

IF(AGGR(SUM({<TIPO_METRICA={'ING'}>}Monto),RAZON_SOCIAL)>=$(vMinimaFacturación) and

   AGGR(SUM({<TIPO_METRICA={'ING'}>}Monto),RAZON_SOCIAL)<=$(vMaximaFacturacion),

   SUM({<TIPO_METRICA={'ING'}>}Monto))