Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with data that looks like this. Noted that the word 'Apple' appeared several times even though it means different things under each instance and belongs under different group / type.
I'm creating a dashboard with a filter for Group1, another filter for Group2, as well as a table listing the keywords & values after I've made the necessary selection under the two filters. For instance, if I select "Type1" under the filter for Group1 and "Brand" under the filter for Group2, the keyword "Apple" and "Samsung" comes up, which is correct and as expected.
However, once I click on "Apple" within my table of keywords and values, the dashboard took it that I wanted to select all instances of the word "Apple" under "Group2" and ignores my previous selection under Group2.
May I seek advice on what I'm doing wrong here. I've attached my sample qvf file for reference. Thank you!
Managed to solve it. Will keep the question and answer here for some strangers' future reference.
The problem lies in the expression I was using for the table in my original attached qvf. The expression that I had use to display the keyword and value was:
"""
=if(GetSelectedCount(Group2)<>1, '-', Keyword)
"""
The correct expression should have been:
"""
=AGGR(ONLY({<Group2={'$(=GetFieldSelections(Group2))'}>} Keyword), Keyword)
"""
Managed to solve it. Will keep the question and answer here for some strangers' future reference.
The problem lies in the expression I was using for the table in my original attached qvf. The expression that I had use to display the keyword and value was:
"""
=if(GetSelectedCount(Group2)<>1, '-', Keyword)
"""
The correct expression should have been:
"""
=AGGR(ONLY({<Group2={'$(=GetFieldSelections(Group2))'}>} Keyword), Keyword)
"""