Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
eduardo_dimperio
Specialist II
Specialist II

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

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

View solution in original post

4 Replies
ahaahaaha
Partner - Master
Partner - Master

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

marcus_sommer

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_dimperio
Specialist II
Specialist II
Author

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

eduardo_dimperio
Specialist II
Specialist II
Author

Thank You Marcus !