Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
mihai_iov
Contributor II

Expressions changing their evaluations results when they shouldn't.

I'm having an issue with a pivot table chart, with multiple employees:
I've written some expressions and checked them with the database, they all calculate the values properly, when a single row in the pivot table is selected, however if I deselect the said dimension, the results are changing without any apparent reason.
I've checked all the possible filters and the only one that is changing is whether the dimension is selected or not. Is this a bug? Am I missing something? I've attached the .qvw, hopefully you can help me figure it out.
For example, in case of Bovenegio, the expression [% Informazione Medica] should return 47.14, which it does if I select Bovenegio.

1 Solution

Accepted Solutions
Partner
Partner

Re: Expressions changing their evaluations results when they shouldn't.

Include your dimensions in the Aggregate:

100*(Sum({<nome = {'Informazione Medica'},role = {'1','2'},macro_area_codice = {'nordOvest'}>} Aggr(RangeMin(1,Sum({<nome = {'Informazione Medica'},role = {'1','2'},macro_area_codice = {'nordOvest'}>} Fraction)),assign_date,macro_area_codice,Cognome,Nome))/[N° TOTALE GIORNI LAVORATIVI])

View solution in original post

7 Replies

Re: Expressions changing their evaluations results when they shouldn't.

Which tab are we looking at?

mihai_iov
Contributor II

Re: Expressions changing their evaluations results when they shouldn't.

Custom Report, table NW

Re: Expressions changing their evaluations results when they shouldn't.

I am not seeing any expression called % Informazione Medica


Capture.PNG

mihai_iov
Contributor II

Re: Expressions changing their evaluations results when they shouldn't.

My bad, it's "%Giorni Informazione Medica "

Partner
Partner

Re: Expressions changing their evaluations results when they shouldn't.

Include your dimensions in the Aggregate:

100*(Sum({<nome = {'Informazione Medica'},role = {'1','2'},macro_area_codice = {'nordOvest'}>} Aggr(RangeMin(1,Sum({<nome = {'Informazione Medica'},role = {'1','2'},macro_area_codice = {'nordOvest'}>} Fraction)),assign_date,macro_area_codice,Cognome,Nome))/[N° TOTALE GIORNI LAVORATIVI])

View solution in original post

mihai_iov
Contributor II

Re: Expressions changing their evaluations results when they shouldn't.

Here's the fields you have to select in the multi-box selects.jpg

mihai_iov
Contributor II

Re: Expressions changing their evaluations results when they shouldn't.

That was it, thanks!