need to show just one dimension in a table

[#1]

I have already add a expression

Avg({$< PAIS = {[COSTA RICA]},TIPO = {'OBJ','REAL','CUMPL'}>}Agosto16)

It works fine but i could not get to show only COSTA RICA in the table.

As you can see in the picture anothers Countrys are been shown in the table.

What can i do to fix this?

Tnks

Adrian

[Anil_Babu_Samineni]

Try like this

Avg({$< PAIS = {'COSTA RICA'},TIPO = {'OBJ','REAL','CUMPL'}>}Agosto16)

[stabben23]

You need to have same set analysis in all expression, Guatemale comes from Setiembre expression.

Use PAIS = {[COSTA RICA]} also in that expression.And all other if there is more.

[#4]

Thanks for the reply, but I got the same result, GUATEMALA is still in the table as well as the others

[stabben23]

if you add PAIS = {[COSTA RICA]} in all expression you will have only Costa Rica

[stabben23]

And the same for TIPO = {'OBJ','REAL','CUMPL'} if that should affect on all expression

[Anil_Babu_Samineni]

You may remove the $  and then try

[#8]

Thank you so much, Got it.

[Peter_Cammaert]

The idea is that in order to hide dimension values, we try to suppress their expression output. Default QlikView behavior will cause those dimension values that produce only 0 or NULL values in all their expressions to be unlisted.

Set Analysis restricts calculations to specific dimension values, but the others will only be hidden if you suppress them in all expressions.

Note that you can disabled this default behavior in the Presentation tab

[rupamjyotidas]

If you are really trying to show only [COSTA RICA], why not do a calculated dimension

If(PAIS='[COSTA RICA]',PAIS)

Don't forget to check'Suppress When NULL'