solution

Wed, 30 May 2012 19:18:22 GMT

I have desined dashboard using more than 10 tables.

it is working fine,but i am facing one problem that when i have not selected any thing

all data in dashboard shows perfectlly but when i select manager name form selection box few rows of

few datatable's not available to show.

can any one suggest,that what are the situation when selecting any thing from slection box

impact table in dashboard.

erichshiino — Thu, 31 May 2012 01:13:31 GMT

HI,

It may not be easy to help you without understanding your data model.. but...

If you have an expression and you want to ignore a selection in a specific field (e.g. Field1), you can use set analysis.

For example, if your expression is sum ( VALUE) and you want to ignore selections in the field 'Field1', you can write the following new expression:

sum ( {<Field1 = >} Value)

You can ignore as many fields as you want:

Sum ( sum ( {<Field1 = , Field2>} Value)

If you want to ignore all selections you can use:

sum ( { 1} } Value)

Hope this helps,

Erich

topic solution in QlikView