topic Same expression, same table but one gives Invalid dimension in QlikView

Same expression, same table but one gives Invalid dimension

CardiMatt02 — Wed, 04 Sep 2024 09:20:12 GMT

I have this expression:

=IF( (moreJourneys - moreJourneysR) > (SUM(corse_perse_norilevanti) - corse_rec_norilevanti_mex), IF( (SUM(corse_perse_norilevanti) - corse_rec_norilevanti_mex) > 0, SUM(corse_perse_norilevanti) - corse_rec_norilevanti_mex, 0 ), (moreJourneys - moreJourneysR) )

I use it in two columns in a table inside one of my app sheets and in one of them everything works fine but in the other column it gives back the error Invalid Dimension.
Qlik says that the expression sintax is fine.

I have no clue on what to do at this point:

Actually i believe the thing creating the problem is sum(corse_perse_norilevanti) but it still make no sense since in the other column it works fine. (Working in the same app, sheet and table)

Thanks for the help ❤️

Re: Same expression, same table but one gives Invalid dimension

tresB — Wed, 04 Sep 2024 09:31:06 GMT

By any chance, one is expression and another is dimension (calculated)? If so, you can't use aggregation function (here - sum) without aggr/total. However, the same expression as expression would work fine

Re: Same expression, same table but one gives Invalid dimension

CardiMatt02 — Wed, 04 Sep 2024 10:15:37 GMT

Thank you, that was the problem. I created another column as Measure and deleted the old one that was a Dimension.

I'm still a noob with Qlik xD