topic Re: Section Access Issue - Not sure what to do? in QlikView

Section Access Issue - Not sure what to do?

denwo2010 — Wed, 25 May 2011 21:20:47 GMT

Hi,

I have the attached Document which is report based on Engineer Utilisation. I want to create a Section Access which is based on the user from which country they are from i.e. FR = France, UK = United Kingdom.

I have issue where if I do a section access it is not bringing all the results that I require.

For Example if I select EngineerID (EngCal) "CEN160", the Engineer Utilisation Detail will show all the resullts I want to see; but once I click on DB = "FR", it removes the rows that are not assoicated to a call no? I still want thes to appear and not sure what the best way round this?

i.e. change the Table design, or can I create a second section access table that looks at the Eng Cal Db and one that looks at the Key Event Table? If that actually would help?

Thanks

Re: Section Access Issue - Not sure what to do?

denwo2010 — Wed, 25 May 2011 22:28:10 GMT

Ok, Ive tried the following (see attached) but not sure if these is logically correct?

Re: Section Access Issue - Not sure what to do?

kaushiknsolanki — Thu, 26 May 2011 08:00:57 GMT

Hi,

I am not sure with your requirement.

Can you please explain with an example.

Regards,

Kaushik Solanki

Re: Section Access Issue - Not sure what to do?

denwo2010 — Thu, 26 May 2011 08:37:47 GMT

Hi Kaushik,

As you can see from the first Document, if you select EngineerID = "CEN160", you will see on the Engineer Utilisation Detail will show all the utilisation for that engineer, if I applied the DB Filter which will eventually be my Section Access to "UK" it will remove thethe ones that does not have a CallNo, I require this information though.

Thanks

Re: Section Access Issue - Not sure what to do?

kaushiknsolanki — Thu, 26 May 2011 08:54:38 GMT

Hi,

If you have observed your DB i.e UK dont have Null CallNo.

So according to the Selection you make that data is filtering out and thus you can not see the null callno.

So as far as i know its not possible.

Regards,

Kaushik Solanki

Re: Section Access Issue - Not sure what to do?

denwo2010 — Thu, 26 May 2011 08:58:04 GMT

Can you think of away to change the table design tro get round this? Thanks

Re: Section Access Issue - Not sure what to do?

kaushiknsolanki — Thu, 26 May 2011 09:29:19 GMT

Hi,

I think you can try this.

Create Straight Table

Add all dimension you want

Add Expression as sum({<DB=>}1)

Due to this expression, the data will not change even if you select the DB.

Hide the expression. from presentation tab in properties of chart

Hope this will help you

Regards,

Kaushik Solanki

Re: Section Access Issue - Not sure what to do?

denwo2010 — Tue, 31 May 2011 09:43:34 GMT

Hi Kaushik,

That doesn't seem to have made any difference; do you know if you can create two section access on one Document.

Thanks

Re: Section Access Issue - Not sure what to do?

denwo2010 — Wed, 01 Jun 2011 08:36:51 GMT

Anyone out there that can help with this?