topic Re: Sheet level restriction in QlikView

Sheet level restriction

Thu, 14 May 2015 11:41:48 GMT

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

Re: Sheet level restriction

Anonymous — Thu, 14 May 2015 11:44:57 GMT

QlikCommunity Tip: How to get answers to your post?

Re: Sheet level restriction

manojkulkarni — Thu, 14 May 2015 11:45:23 GMT

can you share the sample application.

Re: Sheet level restriction

mohammadkhatimi — Thu, 14 May 2015 11:45:57 GMT

Hi...

Please explain your requirement in detail...

Regards,

Mohamamad

Re: Sheet level restriction

awhitfield — Thu, 14 May 2015 11:46:06 GMT

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

Re: Sheet level restriction

dgreenberg — Thu, 14 May 2015 12:11:59 GMT

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.

Re: Sheet level restriction

Fri, 15 May 2015 04:35:46 GMT

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

Re: Sheet level restriction

mohammadkhatimi — Fri, 15 May 2015 04:39:20 GMT

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

Regards,

Mohammad

Re: Sheet level restriction

Fri, 15 May 2015 05:00:44 GMT

Thanks

i am not clear mahammad can u elaborate for me

Re: Sheet level restriction

jagan — Fri, 15 May 2015 05:18:18 GMT

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;

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.

Re: Sheet level restriction

PrashantSangle — Fri, 15 May 2015 05:28:23 GMT

In Script write those 57 Port in either if clause of where to clause.

Regards

Re: Sheet level restriction

Fri, 15 May 2015 05:44:57 GMT

Thanks Jagan

i am sharing the screen

can u see the county/ports the multi boxs in that same multi boxs i have used in 10 sheets

in one sheet only i want to restrict

i have used trigger select in field that 57 ports result is good

but if clear in multi box it is going i had used lock field also can u plz help me

deporcher port

dest port

as u said to right a code in script if i have no opption left i will do that jagan i have to use in only one sheet only know why to right in script that what i think

Thanks once again

Sivaram

Re: Sheet level restriction

mohammadkhatimi — Fri, 15 May 2015 05:46:12 GMT

=aggr(if(rank(Expression),port of loading)),4)<=57,port of loading),port of loading)

=aggr(if(rank(Expression),port of depacher)),4)<=57,port of depacher),port of depacher)

Above expresion is base on Top 57 ports...

Try above expression..

Hope this helps you...

Regards,

Mohammad

Re: Sheet level restriction

jagan — Fri, 15 May 2015 05:47:10 GMT

Hi,

Handling this in script is a best option, if you select with trigger and then if you clear this selection will be gone. So my advice is try to handle that in script level.

Regards,

Jagan.

Re: Sheet level restriction

jagan — Fri, 15 May 2015 05:48:22 GMT

Also maintain this in Excel sheet, so that in future if you want to Add/Remove some ports changing the excel file is enough no need to touch Qlikview files. I always implement like this.

Regards,

Jagan.

Re: Sheet level restriction

Fri, 15 May 2015 06:16:16 GMT

Thanks

I will try with script only

but how can i show the values of this ports in charts using expression

but how in stight table

below are dimension

and exp

how can show the data for this ports only that stright table jagan

Re: Sheet level restriction

jagan — Fri, 15 May 2015 06:20:38 GMT

HI,

In all your expression put this condition in set analysis

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

Regards,

Jagan.