topic Re: Why do values change when I click on table?? in QlikView

Why do values change when I click on table??

jlampard40 — Sat, 16 Nov 2024 01:53:42 GMT

I have created a straight table. The figures don't look like right, until I click on one of the lines and then the values show exactly what I want it to show! The expression I am using is as follows:

=Num(avg({<Activity_or_Demand={'Demand'},Financial_Year={'FY19/20'}>}
Aggr(count({<Activity_or_Demand={'Demand'},Financial_Year={'FY19/20'}>}
Event_Key),Financial_Year_Week)),'#,###.')

This is showing the average weekly demand, for financial year FY19/20, using demand only and counting using Event Key (unique identifier).

The table looks, as per attached (pic 01) at first (wrong figures). But when I click on, say XR, it shows the result in pic02 attached which is the correct figures!!??. Can anyone shed any light on this??

Many thanks.

Re: Why do values change when I click on table??

lironbaram — Wed, 20 Nov 2019 16:23:02 GMT

actually it's not that complicated ,

aggr function is unique because it disregards the table dimensions , so i your case it doesn't consider modality dimension
so you get wrong figures

you need to modify your expression

=Num(avg({<Activity_or_Demand={'Demand'},Financial_Year={'FY19/20'}>}
Aggr(count({<Activity_or_Demand={'Demand'},Financial_Year={'FY19/20'}>}
Event_Key),Financial_Year_Week,Modality)),'#,###.')

Re: Why do values change when I click on table??

jlampard40 — Wed, 20 Nov 2019 16:50:00 GMT

Thanks very much! Best regards