Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
eduardo_dimperi
Not applicable

Using Set Analysis

Hi everybody

I've some names to filter, like CAS-SUM and CAS-SUM NG

Already exist a code to get CONSUMO_MENSAL if name= CAS-SUM, but now i need to get CAS-SUM and CAS-SUM NG

How can i do this?

Sum({<NAME={"CAS-SUM"}, CORTADO={"Cortado"}>} CONSUMO_MENSAL)

I thought to do this Sum({<NAME={"CAS-SUM*"}, CORTADO={"Cortado"}>} CONSUMO_MENSAL), is this right or exist a better way to?

1 Solution

Accepted Solutions
marcus_sommer
Not applicable

Re: Using Set Analysis

You could use a value-listing like:

Sum({<NAME={'CAS-SUM', 'CAS-SUM NG'}, CORTADO={'Cortado'}>} CONSUMO_MENSAL)

and also a wildcard should work:

Sum({<NAME={'CAS-SUM*'}, CORTADO={'Cortado'}>} CONSUMO_MENSAL)

by using single-quotes to wrap the string-values.

- Marcus

4 Replies
ahaahaaha
Not applicable

Re: Using Set Analysis

At first sight everything right and should work. Really Work? What's the question?

marcus_sommer
Not applicable

Re: Using Set Analysis

You could use a value-listing like:

Sum({<NAME={'CAS-SUM', 'CAS-SUM NG'}, CORTADO={'Cortado'}>} CONSUMO_MENSAL)

and also a wildcard should work:

Sum({<NAME={'CAS-SUM*'}, CORTADO={'Cortado'}>} CONSUMO_MENSAL)

by using single-quotes to wrap the string-values.

- Marcus

eduardo_dimperi
Not applicable

Re: Using Set Analysis

The question is about the best way to do, if way that i did is more efficient.

eduardo_dimperi
Not applicable

Re: Using Set Analysis

Thank You Marcus !