Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Cameron94
Partner - Contributor III
Partner - Contributor III

Ignore a set selection in a chart

Hey all, looking to ignore a selection in a chart as I would like to show all items from the select group in this specific chart. 

Example: IF((vDimension_Period) ='FX_Rates_YearMonth',AVG([Exchange_Rate]),

I want to ignore the( [Exchange _Rate]) field. I have tried adding = to the end but this hasn't worked, can anyone shed any light on this? 

Id either like to ignore the field or have an expression that allows me to show all of this particular measure. 

Thanks 🙂 

Labels (5)
1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

If you want to ignore the user selection in a specific field, then you should use a set expression inside your aggregation function:
Avg({<[Exchange_Rate]=>} [Exchange_Rate])

View solution in original post

2 Replies
hic
Former Employee
Former Employee

If you want to ignore the user selection in a specific field, then you should use a set expression inside your aggregation function:
Avg({<[Exchange_Rate]=>} [Exchange_Rate])

sidhiq91
Specialist II
Specialist II

@Cameron94  it would be something like below:

Avg({<[Exchange_Rate]=,vDimension_Period={'FX_Rates_YearMonth}>} [Exchange_Rate])

If it resolves your issue, please like and accept it as a solution.