Doubt about one easy expression with set analysis

[#1]

Hi everybody.

Hi have to do count(money) when Concept = instalation

this should be like this

Count(DISTINCT{<Concept={'instalation'}>}money)

BUT in my tables i have "big instalations", "small instalations", "medium instalations",

How i "concatenate" this 3 fields? should i sum them in the code or what?

Thank you, greetings!

[#2]

Hi Jeremias,

are these possible values in the one field? If so you can specify all three in the set

Count(DISTINCT{<Concept={'big instalations','small instalations','medium instalations'}>}money)

or use a wildmatch on 'instalations' in the set if you want to count any value that contains the word

Count(DISTINCT{<Concept={'*instalations*'}>}money)

hope that helps

Joe

[alexandros17 · Accepted solution]

If (as I suppose) big, small and medium installation are values for the field Concept your expression is:

Count(DISTINCT{<Concept={'big instalations', 'small instalations', 'medium instalations'}>}money)

let me know

[#4]

for more information on set analysis maybe have a look at this

http://community.qlik.com/docs/DOC-4951

[rustyfishbones]

Hi,

You can use * as the Wildcard in Set Analysis

COUNT(DISTINCT ({<Concept = {'*instalations*'}>} money)

[#6]

Yes, they are values for the field Concept.

Thank you!