topic Re: set analysis in QlikView

set analysis

mambi — Fri, 17 Jan 2014 20:44:13 GMT

Hi everyone,

from the table below i want to get in a text object the number of countries how don't have the value: 'music' in the Market list

thanks

Gysbert_Wassenaar — Fri, 17 Jan 2014 20:55:20 GMT

=count(DISTINCT {<Countries=e({<Market={'music'}>}Countries)>} Countries)

agilos_mla — Fri, 17 Jan 2014 21:01:39 GMT

Maybve not the most elegant way but it does the job:

=count(DISTINCT {<Country=E({<Market={'Music'}>} Country)>} Country)

Rgds,

Michael

mambi — Fri, 17 Jan 2014 21:18:44 GMT

Thanks Sir,