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

[swuehl]

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

[#3]

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

[swuehl]

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

[#5]

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

[swuehl]

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?

[#7]

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

[swuehl]

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

[#9]

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...

[#10]

Thank you, swuehl,

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

Thanks,

Dust