data help

[Anonymous]

Hello Guys,

I stuck in a problem where I need to get the association in all the sheets

]

[miguelbraga]

I've analyzed your Dashboard and found that in the Balance Sheet you didn't use the same Period expression as the others sheets. Change the field in the Listbox to <Expression> and put this:

=if(Period = 'P 00 - 2015','',

if(Period = 'P 01 - 2015','',

if(Period = 'P 02 - 2015','',

if(Period = 'P 03 - 2015','',

if(Period = 'P 04 - 2015','',

if(Period = 'P 05 - 2015','',

if(Period = 'P 06 - 2015','',

if(Period = 'P 07 - 2015','',

if(Period = 'P 08 - 2015','',

if(Period = 'P 09 - 2015','',

if(Period = 'P 10 - 2015','',

if(Period = 'P 11 - 2015','',

if(Period = 'P 12 - 2015','',

if(Period = 'P 13 - 2015', '',

if(Period = 0, '',Period

)))))))))))))))

Hope it solved your problem.

[Anonymous]

Hello Braga

thanks for the quick help, but if I change and if I do selection on the field

the values in the other sheets are changing to no data.

could you please share qvw if you find the correct way to do it?

[rubenmarin]

Hi John, the 'Period' field laoden in BS table has a format of 'P nn - YYYY', mwanwhile, the period from the calendar and Data table is a number.

This causes that any selection in Dta table will filter the 'Period' values wich doesn't have a related value in BS table.

Try loading Period field in BS table as:

num(mid(Period,3,2)) as Period

[rwunderlich]

You are using two different types of values for Period:

"P 01 - 2015" and "1".

Therefore the tables do not link correctly. In your Period listbox, you are using an expression that includes only the "n" values. A selection in that listbox will excluded any data for tables that use the "P nn - 2015" tables.

Modify one or the other so Period is consistent through all tables.

-Rob

[Anonymous]

Hi Rob

thanks for your suggestion.

could you please suggest me with an app where or which period needs to be changed

if I change any I am not getting any values in the charts

please suggest me with an app. Hoping for your resposne

[Anonymous]

Hi Ruben

after trying with your suggestion I am getting zero values in the charts

could you please try and let me know?

hoping for a positive response

[rubenmarin]

Hi John, I'm unable to try beacuse I'll need to reload the document.

In script, 'Balance Sheet' tab I would cahnge "Period" to "num(mid(Period,3,2)) as Period" in the 3 tables ([BS BUDGET], [BS FORECAST] and [BS ACTUAL])