Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
New 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



Tags (1)
3 Replies

Re: AGGR on Qliksense

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


Re: AGGR on Qliksense

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.

Re: AGGR on Qliksense


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