Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
vinayk1
Contributor
Contributor

The numbers of the metrics are not being aggregated for all the region selection in filter

I have 5 regions in filter panel, when one region is selected corresponding values populate.

However when 2 or more regions are selected the values do not populate in the tables and charts.

any suggestion to solve this issue.

Please help.

Thank You

Labels (6)
6 Replies
Aditya_Chitale
Specialist
Specialist

Please share sample data  or screenshots of what exactly is happening.

Your explaination is too short to understand the exact problem.

 

Regards,

Aditya

vinayk1
Contributor
Contributor
Author

vinayk1_0-1692875706912.png

when i select only one region values populate but when i select multiple regions nothing populates 

vinayk1_1-1692875807506.png

I am unable to under stand what the issue is

 

Aditya_Chitale
Specialist
Specialist

From your provided screenshots I can only suggest you to check if any getselectedcount() function is applied to show measure numbers only if filter field is selected.

Are you able to see numbers without selecting any value from filter ?

Also if possible can you share measure expression of any measure which is showing null values on multiple values selection from filter ?

 

Regards,

Aditya 

vinayk1
Contributor
Contributor
Author

No i am unable to see values when no selections are made on the region

vinayk1
Contributor
Contributor
Author

MTD FY22 actuals set expression

Sum({$<Month={"=$(vToDateSecondLastYear)"},Version={'PYACT_CYBUDRATE - PY Actuals at CY Budget Rate'},FY={'FY22'}, Value_Month=,GL_Name-={'Royalty Income Third Party'}>} Value_Lc_Euro*$(vCurrency))

Aditya_Chitale
Specialist
Specialist

Expression doesn't contain any such condition applied. Only solution I could suggest now is adding all the filter fields from set analysis separately in a table and evaluate each field after filter selection.

Especially check the variable values. Whether the variable value gets affected after multiple filter selections

 

Regards,

Aditya