Initial Select on Screen

[#1]

Hi everyone,

In my Qv document, I have a straight table and bar chart for 9 regions. But, always, Qv shows 7 of 9 regions and leaves out 2 regions: Norgistics and WCSA.

Anyone knows why Qv does that?

Thanks in advance

Nancy

[#2]

Oswaldo:

Tal como le cuento a Jaime, no sé que hacer para que la primera vez que entro me muestre las 9 regiones en vez de 7

Saludos

Nancy

[mphekin12]

Maybe your document 'On Open' event has triggers associated with it that are selecting 7 or your 9 regions.

[#4]

Creo que ya sé donde puede estar el problema... pero no sé como solucionarlo

En la pantalla inicial se muestran 3 indicadores que se alimentan de 3 hojas excel diferentes, donde la clave que las une es el campo Region...

Estas 3 planillas excel contienen información diferente para cada región y están enlazadas por la Region por un tema de seguridad (pues, yo le doy acceso a los usuarios dependiendo de la región a la que pertenezcan).

El tema es que para una de estas 3 fuentes no hay datos en las regiones Norgistics y WCSA...

Puede ser que de ahí parta restringiéndome de todas las vistas estas 2 regiones???

Porque el problema lo tengo cuando entro a la pantalla que se basa en la planilla para la cual estas regiones Sí tienen datos...

No sé si se entiende. Ahora voy a ver como traduzco todo esto a Inglés.

Saludos

Nancy

[#5]

Hi,

I think I know where it can be the problem ... but I don't know how to fix it .

In the main screen, I have three indicators that feed on 3 different excel sheets, where the key that links all 3 sources is the Region field which is displayed on the initial screen ...

These three excel spreadsheets contain different information for each region, and they are linked by the Region for a security issue (because I give access to users depending on the region which they belong).

The issue is that for 1 of these 3 sources there are no data in regions Norgistics and WCSA ...

Can I restrict myself in all the views for these two regions because of this??

Due to before, I have this problem when I get to the screen which is based on the source with data on these 2 regions ...

[#6]

Hi,

Just try to upload year and region alone in a new demo application with out any other constraints and check if its work fine for your selection and if so, then check with other constraints as well.

[#7]

I did it...

Because of that, I found this connection between 3 sources through region field, and I discovered that 1 of these 3 sources have no data for the 2 regions which not appear in following selections...

[#8 · Accepted solution]

Ok, then you can click on show null values in the chart properties or verify if the null values are excluded in the chart property as well?

or

In the script provide some dummy values to the fields to replace the null values for that 2 regions

[#9]

Thanks!!!

I include dummy values in source with no data for 2 regions and problem solved

Thanks!