topic dimension with conditions in QlikView

dimension with conditions

Mon, 21 Nov 2016 18:53:53 GMT

Hello!.

I need aggregate one expression a one dimensional. This does not have to show projects with cant = 0

the column Cant. has the expression:

count({<EstadoVigente = {1}, Estado = {'PROMESADA','BLOQUEADA'}>}SuperficieVivienda)

and the dimensional is:

Proyecto

The table has to show alone two rows:

Proyecto 3 and Proyecto 4

You help me please!

Thanks

sunny_talwar — Mon, 21 Nov 2016 19:01:12 GMT

You can probably use a calculated dimension here and replace Proyecto with

Aggr(If(count({<EstadoVigente = {1}, Estado = {'PROMESADA','BLOQUEADA'}>}SuperficieVivienda) <> 0, Proyecto), Proyecto)

and remember to check 'Suppress When Value Is Null' on the dimensions tab.

Or you can use a if statement to make sure all the other expressions are 0 or null where Cant. is 0.

If([Cant.] <> 0, Expression2)

If([Cant.] <> 0, Expression3)

and so on....

Mon, 21 Nov 2016 20:53:12 GMT

Perfect!! thanks you very much