topic Re: Qliksense Set Analysis - Look Up Value in App Development

Qliksense Set Analysis - Look Up Value

NormanStanleyBadger — Fri, 02 Jul 2021 13:21:47 GMT

Hi - is it possible to use a selection as a look up value for other tables?

Example : On selecting a client's name, another table (containing all records) is filtered to that particular client's market segement

Re: Qliksense Set Analysis - Look Up Value

chriscammers — Fri, 02 Jul 2021 14:00:31 GMT

Yes.

You override the customer selection and then select from the possible market segment values.

Sum({<CustomerName =,MarketSegment = {$(=Concat(distinct chr(39) & MarketSegment & chr(39),','))}>}CYBookingAmount)

Re: Qliksense Set Analysis - Look Up Value

NormanStanleyBadger — Fri, 02 Jul 2021 14:48:32 GMT

Thanks for the reply. I am half way there.

How do I get the market segment of the selected client? The plan is for the user to be able to select any of their clients and compare their performance with the client's segment.

Re: Qliksense Set Analysis - Look Up Value

chriscammers — Fri, 02 Jul 2021 15:04:11 GMT

The expression that I posted does that. Let's break it down a little.

Sum({< CustomerName =, //Ignore the customer selection MarketSegment = { //calculate the possible market segment values as a comma separated list enclosing each value in single quotes $(= //Dollar Sign expansion forces this expression to calculate first Concat(distinct chr(39) & MarketSegment & chr(39),',') //Concat makes a delimited list based on the possible values of Market Segment ) } >} CYBookingAmount )

Re: Qliksense Set Analysis - Look Up Value

NormanStanleyBadger — Fri, 02 Jul 2021 16:10:52 GMT

Thanks that’s very useful.

I am getting a list of five possible market segments in the delimited list but I only want to return the one related to the client without any selections. What am I missing?