Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
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
for more information on set analysis maybe have a look at this
http://community.qlik.com/docs/DOC-4951
Hi,
You can use * as the Wildcard in Set Analysis
COUNT(DISTINCT ({<Concept = {'*instalations*'}>} money)
Yes, they are values for the field Concept.
Thank you!