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: 
Not applicable

Reflecting Set Analysis results in listbox

Hi,

I'm using Set Analysis in a chart, which works fine. according to a selected value,

the appropriate customers are taken into account in the chart.

But in a Listbox with the customers names, the irrelevant customers are not greyed.

My question is: how to reflect set analysis results in the linked dimensions?

Thanks!

4 Replies
tresesco
MVP
MVP

The relevance of a field selection works when another field is selected. Set Analysis is used in expression and it calculates the result accordingly. No selection gets affected by set analysis, rather it behaves otherwise (and if you think a bit would find that - that is not logical also.) I think what you want is not wha you are writing. Your set analysis is not dynamic, you have defined that in expression during development and you would probably not want your selection status to be so (static).

Thanks.

Not applicable
Author

Hi,

Well, using set analysis or rather indirect one, was the only choice, to reflect a dynamic value selection,

which involved 2 fields.

I'm quite sure that the user will demand now to see the customers which are taken into account by the set analysis,

not only in the chart, but also in the corresponding listbox.

tresesco
MVP
MVP

Can you please share the logic you are using Set Analysis for? May be that will help address your problem.

Thanks.

Not applicable
Author

Hi,

if we can elaborate on the famous example:

sum({$<CompanyName = p({$<CategoryName={'Baby Clothes'}>}

CompanyName)>} Sales)

assuming that we have an additional list box with the field CompanyName.

Would the customers that were not selected by the above set analysis (i.e., not purchased Baby Clothes)  would be greyed?

Thanks!