Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
User12321
Contributor III
Contributor III

Input selections from filter to another field

Hi,

I have fields MonthYear, Outlet, SurveyMonthYear, SurveyOutlet and Score.

I want to link filters MonthYear to SurveyMonthYear and filters Outlet to SurveyOutlet as the score only appears when a value for MonthYear filter is selected.

How can I display the score when no filter is selected? Can someone help please. Thank you.

Labels (1)
3 Replies
OmarBenSalem

Hello,

Try this :

Avg({<SurveyMonthYear={$(=Concat(distinct ''''&MonthYear&'''',','))}>}Score)

per analogy :

Capture.PNG

Capture.PNG

User12321
Contributor III
Contributor III
Author

Hi @OmarBenSalem ,

When I added in Outlet, the score is wrong. Is it because some outlets do not have a score but the average considers them into the calculation? How can I resolve this?

OmarBenSalem

I think so yes !

try to situate these outlet in your script maybe with something like this :

if(len(trim(score))=0,0,1) as FlagScore

and add this in your expression 

Avg({<SurveyMonthYear={$(=Concat(distinct ''''&MonthYear&'''',','))}, SurveyOutlet={$(=Concat(distinct ''''&Outlet&'''',','))} ,FlagScore={1}>}Score)