topic Re: Expression without total dimension in QlikView

Expression without total dimension

Wed, 04 Jul 2012 14:28:21 GMT

Hi everybody. My english is not good but i hope you can understand me.

I attached an image because I need your help. The fields "F. Desde", "F. Hasta" and "Notas" are only informative, i do not calculate with this fields. So I need show null value for the total by dimension to this fields.

In the picture are marked with red totals I want to display a null value.

I hope my explanation is understood.

Thanks all and regards.

Luciano Muñoz.-

Re: Expression without total dimension

fosuzuki — Thu, 05 Jul 2012 01:24:24 GMT

Hi,

try using the Dimensionality() function, to check wether the expression is evaluating the value for a detail line or for a (sub)total line. Something like:

if(Dimensionality()=x, Fecha)

Hope this helps you

Fernando

Re: Expression without total dimension

Tue, 10 Jul 2012 11:42:16 GMT

Thank you very much, this solve my problem.

Regards.

Luciano Muñoz.-