topic Re: Doubt about one easy expression with set analysis in QlikView

Doubt about one easy expression with set analysis

Fri, 09 Jan 2015 15:54:42 GMT

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!

Fri, 09 Jan 2015 15:56:55 GMT

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 — Fri, 09 Jan 2015 15:57:08 GMT

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

Fri, 09 Jan 2015 16:01:49 GMT

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

rustyfishbones — Fri, 09 Jan 2015 16:04:25 GMT

Hi,

You can use * as the Wildcard in Set Analysis

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

Fri, 09 Jan 2015 16:04:37 GMT

Yes, they are values for the field Concept.

Thank you!