topic Re: data model help in QlikView

data help

Anonymous — Mon, 19 Oct 2015 08:55:13 GMT

Hello Guys,

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

]

Re: data model help

miguelbraga — Mon, 19 Oct 2015 09:12:13 GMT

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.

Re: data model help

Anonymous — Mon, 19 Oct 2015 09:16:14 GMT

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?

Re: data model help

rubenmarin — Mon, 19 Oct 2015 09:19:55 GMT

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

Re: data model help

rwunderlich — Mon, 19 Oct 2015 09:23:05 GMT

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

Re: data model help

Anonymous — Mon, 19 Oct 2015 10:34:24 GMT

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

Re: data model help

Anonymous — Mon, 19 Oct 2015 10:35:43 GMT

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

Re: data model help

rubenmarin — Mon, 19 Oct 2015 10:41:46 GMT

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])