Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
jlampard40
Contributor III
Contributor III

Why do values change when I click on table??

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.

Labels (2)
1 Solution

Accepted Solutions
lironbaram
Partner
Partner

hi 

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)),'#,###.')

View solution in original post

2 Replies
lironbaram
Partner
Partner

hi 

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)),'#,###.')

View solution in original post

jlampard40
Contributor III
Contributor III
Author

Thanks very much!  Best regards