topic How to exclude data from dashboard project in QlikView

How to exclude data from dashboard project

Wed, 02 Nov 2011 13:26:08 GMT

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

How to exclude data from Qlikview project

swuehl — Wed, 02 Nov 2011 13:30:40 GMT

Sorry, I don't get what you mean with above statement. Could you explain it?

I would suggest using a where clause in your Date load instead, something like

LOAD *

FROM table where DIVISION not 'DONTWANTTHISDIVISION';

Hope this helps,

Stefan

How to exclude data from dashboard project

Wed, 02 Nov 2011 13:43:26 GMT

Thank you, swuehl.

Sorry, I need exclude one division data from dashboard project.

This dashboard project is developed by third party and I just need to do some custom thing. Some hide scrip I cannot see.

Thanks,

Dust

How to exclude data from dashboard project

swuehl — Wed, 02 Nov 2011 14:19:37 GMT

You want to exclude this data on a per user base? Like UserA can't see Division A and UserB can't see DivisionB?

Then you might want to check out section access.

If you want to permanently exclude one division for all users, I again would do this in your data load with a where clause.

Or are you saying you don't have access to the script? I assumed you had, because you were talking about the LET statement in your OP.

Anyway, I think you need to describe your data model, setting and user requirements a bit more detailed.

Regards,

Stefan

How to exclude data from dashboard project

Wed, 02 Nov 2011 14:31:01 GMT

Thank you.

I should say I don't want to modify the original program and add some script to exclude the data for all user.

Is there a way qlikview can exclude the already loaded data?

Some hide scrip I cannot see.

Thank you and best regards,

Dust

How to exclude data from dashboard project

swuehl — Wed, 02 Nov 2011 14:36:24 GMT

Ok, maybe like this:

Do the selection on division as you need, i.e. select all division that you want to keep.

Then go to file -> reduce data -> keep possible values.

Then you might store the application to a different name and distribute. As long as you don't reload, the excluded division is removed from the data completely.

Something like this?

How to exclude data from dashboard project

Wed, 02 Nov 2011 14:42:30 GMT

Thank you.

This program need reload everyweek to pickup the latest data. 'reduce data' may need to do after every load.

Sorry, I am a newbie to Qlikview.

Best regards,

Dust

How to exclude data from dashboard project

swuehl — Wed, 02 Nov 2011 14:49:31 GMT

You don't want to modify the original program, but maybe adding some lines?

If you do a resident load of the table with the division name, and use a where clause in this load, then drop the original table, this might be enough. But for sure, you will need some insight into the script and data model.

TABLEWITHOUTDIVISION:

NOCONCATENATE LOAD *

From TABLEWITHDIVISION where Division not 'NOTTHISONE;

drop table TABLEWITHDIVISION;

I am not sure, do you want to remove the data from the data model, i.e. noone will have access to the data after reload even if modifying the GUI, or do you just want to limit the possible selection state (but if a user modifies the GUI objects, he might access the data again)?

How to exclude data from dashboard project

Wed, 02 Nov 2011 17:19:44 GMT

Do you have an example?

Could you use set analysis so that the dashboard information excludes figures relating to a particular division? I guess that depends on what kind of data it is you're trying to show...

How to exclude data from dashboard project

Wed, 02 Nov 2011 17:36:43 GMT

Thank you, swuehl,

I am trying this and cannot get it work.I can remove the data from data model.

Thanks,

Dust

How to exclude data from dashboard project

Wed, 02 Nov 2011 17:38:16 GMT

Hi rbiscoeodi,

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

Thanks,

Dust

How to exclude data from dashboard project

swuehl — Wed, 02 Nov 2011 17:47:14 GMT

Could you post the script code?

How to exclude data from dashboard project

Wed, 02 Nov 2011 18:24:23 GMT

Hi swuehl,

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

My email: dzl88@hotmail.com

Thanks,

dust

How to exclude data from dashboard project

Thu, 03 Nov 2011 15:00:02 GMT

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.

How to exclude data from dashboard project

Thu, 03 Nov 2011 15:10:39 GMT

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.

How to exclude data from dashboard project

Mon, 14 Nov 2011 17:45:11 GMT

Hi Dave,

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

Thanks,

Dust

Re: How to exclude data from dashboard project

Mon, 14 Nov 2011 17:47:50 GMT

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