topic Re: Problema con Dimensiones calculadas / Problem with Calculated dimensions in QlikView

Problema con Dimensiones calculadas / Problem with Calculated dimensions

Wed, 14 Nov 2012 19:32:06 GMT

Buenas tardes / Good afternoon

Hola, soy nuevo en esto, tengo dos campos [REGION] y [GERENCIA], trato de que en una grafica de barras me presente como dimension la [REGION] cuando no hay ninguna seleccionada, y si existe una seleccion de [REGION] en su lugar me grafique los datos de [GERENCIA], para esto uso el siguiente codigo dentro de una dimension calculada, no funciona.


=IF(COUNT(DISTINCT REGION)=1,GERENCIA,REGION)

Gracias de antemano.

------------------------------------------------------

Hi, I'm new at this, have two fields [REGION] and [GERENCIA], I'm trying to get a bar chart with [REGION] as dimension when there is no one selected, and then, if there is one [REGION] selected, it present me [GERENCIA] as dimension instead. For this I'm adding a calculated dimension with the code its up there. It dosnt work.

Thanks in advance.

(Sorry for my poor english, lol)

Fernando Urbina

Re: Problema con Dimensiones calculadas / Problem with Calculated dimensions

MayilVahanan — Wed, 14 Nov 2012 19:35:38 GMT

Try like this

=if(GetSelectedCount(REGION)=1,GERENCIA,REGION)

Hope it helps

Re: Problema con Dimensiones calculadas / Problem with Calculated dimensions

Wed, 14 Nov 2012 19:36:40 GMT

It looks like you want if(GetSelectedCount(REGION)=1, GERENCIA, REGION)

Re: Problema con Dimensiones calculadas / Problem with Calculated dimensions

Wed, 14 Nov 2012 21:53:16 GMT

Thank you both for the fast answers, is there any page where i can found more functions like that?, would be really helpfull.

Thank you again

Fernando.

Re: Problema con Dimensiones calculadas / Problem with Calculated dimensions

MayilVahanan — Wed, 14 Nov 2012 22:00:33 GMT

You can learn from the help. Please click F1 and you can get it the help book.