topic Re: set analysis issue in QlikView

set analysis issue

Wed, 25 Nov 2020 16:16:04 GMT

how to display 97 countries out of 100 ,

3 are excluded by using set analysis

????

heip me

thanks in advance

sunny_talwar — Mon, 13 Feb 2017 13:03:12 GMT

May be like this:

Sum({<Countries -= {'Country1', 'Country2', 'Country3'}>} Measure)

Chanty4u — Mon, 13 Feb 2017 14:10:21 GMT

May be try this also

sum( {$<Countries = E({1<Countries ={‘C1’,'C2','C3'}>})>} Measure)

Mon, 13 Feb 2017 15:11:18 GMT

i have to display 97

it has to change dynamically as selection made in list box

vishsaggi — Mon, 13 Feb 2017 15:40:18 GMT

Where do you want to display these countries? In a list box or a text box or a straight table?

IN text box try this:

= IF(Not Match(Country, 'Country1', 'Country2', 'Country3'), Concat(Country, '|'))

kaushiknsolanki — Mon, 13 Feb 2017 15:44:22 GMT

Hi,

Try this expression.

Sum({1-$}Measure)

Regards,

Kaushik Solanki

sunny_talwar — Mon, 13 Feb 2017 16:04:51 GMT

Do you mean if you select 10 out of the 97 countries, the expression should just show those 10? I think the expression should already do that.

Tue, 14 Feb 2017 04:55:12 GMT

thanks to all

for the answers