Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

mambi
Contributor III

set analysis

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

Countries

Market

France

video games

France

music

France

books

France

tourisme

Spain

books

Spain

tourisme

Deutch

video games

Deutch

music

Deutch

books

Deutch

tourisme

Deutch

cars

Deutch

job

thanks

Tags (2)
1 Solution

Accepted Solutions

Re: set analysis

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


talk is cheap, supply exceeds demand
3 Replies

Re: set analysis

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


talk is cheap, supply exceeds demand
agilos_mla
Contributor III

Re: set analysis

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

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

Rgds,

Michael

mambi
Contributor III

Re: set analysis

Thanks Sir,

Community Browser