Sheet level restriction

[#1]

Hi All,

I want to show only 57 ports data only in one sheet how can i do

i had tried to using triggers in sheet it is not that much effective

Thanks

sivaram

[Anonymous]

QlikCommunity Tip: How to get answers to your post?

[manojkulkarni]

can you share the sample application.

[mohammadkhatimi]

Hi...

Please explain your requirement in detail...

Regards,

Mohamamad

[awhitfield]

In other words .... your post doesn't really make sense at all!!

[dgreenberg · Accepted solution]

I am guessing that what you want is when you click on a specific sheet data is filtered so it only shows entries for port 57? 

If that's the case there are many ways.

Try having a hidden filter on port and an action on the sheet to set the filter to 57.  Be sure to also lock the filer so a clear won't clear it.  Then when activating any other sheet clear he filter and unlock it.  If you don't want the filter showing in current selections you can use the hideprefix in your script and rename the field to something like %Port.

[#7]

sorry for delay response Daniel

i will explain  my requirement there is multi box in which to fields r their

port of loading

port of depacher

this field their are many values  client want to see only 57 ports values in that sheet how to restrict those field 

[mohammadkhatimi]

Using RANK function u can restrict or in Properties dimension tab u can restrict from there also...

Regards,

Mohammad

[#9]

Thanks

i am not clear mahammad can u elaborate for me

[jagan]

Hi,

Create a flag for that 57 ports and use it in the expressions of charts, so that it will be filtered automatically in charts.

Example:

LOAD

*,

If(WildMatch(Port, 'Port1', 'Port2', .........................., 'Port57'), 1, 0) AS PortFlag

FROM DataSource;

OR

Put those ports detials in excel file and load like this

Data:

LOAD

*

FROM DataSource;

PortsRestriction:

LOAD

Port,

1 AS Flag

FROM PortRestrictionFile;

Now in charts use this expression

Sum({<PortFlag = {1}>} MeasureName)

Hope this helps you.

Regards,

Jagan.