How to exclude data from dashboard project

[#1]

Hello everyone,

I am trying to exclude one division's data from the whole dashboard. I tried to use the include file:

LET ORG_NAME2<> Not Need DIVISION;

It looks not work.

Do you have any thoughts on that? Or do you have any suggestion on my needs.

Thank you inadvance and best regards,

Dust

[#2]

Hi rbiscoeodi,

I canot send the example because it so big. What's set analysis? Where I can modify it.

Thanks,

Dust

[swuehl]

Could you post the script code?

[#4]

Hi swuehl,

Can you give me your email? I can set a goto meeting at your convienent.

My email: dzl88@hotmail.com

Thanks,

dust

[#5]

You might try one of the Document Event Triggers, for example:

Click Settings

Click Document Properties

Click Triggers

Click OnOpen

Click Add Action(s)

Click Add

Click Selection

Click Select in Field

Click OK

Choose your Field

Enter the Division name to be hidden

Click Add again for another Action

Click Selection

Click Select Excluded

Click OK

Choose your Field

Click Apply and/OK twice

Save the QVW

Close it and re-open it

The Division name to be excluded will not be in the data

If OnOpen isn't the best Trigger for you, try one of the others.

[#6]

There are full details on Set Analysis in the QlikView help file - that will give you far better information than me trying to explain it.

However, to give an example, if your dashboard is trying to show the sum of sales for all divisions, with Division X excluded, then the set analysis you would use in the chart is something like:

=sum( {$<~Division = {Division X} >} Sales)

This may be completely not what you're after, but without being able to see what's on your dashboard it's a bit hard to tell.

[#7]

Hi Dave,

You answer is very close. Here is the method I am using now. Please see attached file for detail.

Thanks,

Dust

[#8]

Hi All,

Thank you veyr much for your inputs. You are great. Here is the method I am using now. Please see attached file for more detail.

Best regards,

Dust