Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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

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

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

Tags (1)
3 Replies

Re: AGGR on Qliksense

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

Employee
Employee

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

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