12 Replies Latest reply: Aug 7, 2012 5:27 AM by ztarique RSS

    Help Needed!!

      Hi,

      I have attached the snapshot of the error which i am getting..

      This happens as soon as i reload the script..

      Can any one help me with this?

      Thanks in advance

      Capture.JPG

        • Re: Help Needed!!
          Mayil Vahanan Ramasamy

          Hi

            This gives information about data fetching in particular table which you mentioned in the script. After sucesful fetched this dialog box disappear because tick of close when finished at the bottom..  For every reload it checks all data fetchibg correctly or not.

           

           

          hope it helps

            • Re: Help Needed!!

              Hi,

              thanks for replying..in an ideal scenario it does disapper, but in my case it hangs and i am forced to restart qlikview. Also, the script which is supposed to be executed does not get executed..

                • Re: Help Needed!!
                  Adam Abwat-Johnson

                  Hmmm,

                   

                  I wonder if the reason it is hanging is because QlikView is creating 'synthetic keys'.

                   

                  Have the tables "Dec-Mar_USD" and "Dec-Apr"_USD got the same field names in them? If so then QlikView will try to create relationships on these fields and could take quite a long time, depending on how many fields you have in common in the two tables.

                   

                  Are you aware of the 'Qualify' keyword? This may help you to stop QlikView relating the fields in the two tables together and then you will be able to look at the results.

                   

                  Hope this helps,

                   

                  Chris

                    • Re: Help Needed!!

                      Hi Chris,

                      Thanks for replying..yes "Dec-Mar_USD" and "Dec-Apr"_USD has the same field name in them..The issue is sorted now..one of the colums in one sheet did not match the other..

                       

                      Could you give a little idea about the qualify keyword? Since i am very new to this, I am still in the exploring mood.

                       

                      Thanks a lot

                    • Re: Help Needed!!
                      Mayil Vahanan Ramasamy

                      hi

                       

                      i think in script any issues..did u check it. did u give same name for all table name.try debug instead of reload n give limited data to fetch . hope it helps

                        • Re: Help Needed!!

                          Hi Mayil,

                          The issue is sorted now..one of the colums in one sheet did not match the other..

                           

                          thanks a ton..

                            • Re: Help Needed!!
                              Adam Abwat-Johnson

                              Sorry, had to disappear into a meeting. Glad you got it sorted though, off to the next challenge!

                               

                              Chris

                                • Re: Help Needed!!
                                  Adam Abwat-Johnson

                                  Just briefly, using Qualify on particular fields will insert the table name before the field name so for example the "Exchange Rate" field in the Currency table would become "Currency.Exchange Rate". This means that if you have another field called "Exchange Rate", because the field names are now different, QlikView will not make a relationship between the two.

                                   

                                  I'm sure the help will probably explain it better than I have!

                                   

                                  As you have seen though, you can fix the problem without the need to use the Qualify keyword which is great. Usually I find that using the Qualify keyword is just a temporary thing before I have fully developed my data model.

                                   

                                  Keep exploring, I've been using QlikView for the best part of 2 and a half years and I still am!

                                   

                                  Chris

                                    • Re: Help Needed!!

                                      Hi Chris,

                                      Thanks a lot..Shall keep you in the loop if I run across any difficulties..

                                        • Re: Help Needed!!

                                          Hi Chris, I come to you again with a small doubt with section access.

                                          So, what i am looking for is a simple section access security with user id, password and OMIT options. I want a particular user to to view a certain fields.

                                          To make it clear. Lets take an example.

                                          I have a field called country which has 10 countries(US, GBR etc) as drop down. If I use OMIT in section access, i believe I can hide a particular field. In my case, if I omit country. the entire country field will be invisible. But, what I want is to omit a particular country from the field. ie: if i want to omit only GBR from the list of countries, how do I do it?

                                           

                                          Could you help me with this please?

                                           

                                          Thanks in advance

                                            • Re: Help Needed!!
                                              Adam Abwat-Johnson

                                              Hi again,

                                               

                                              Section Access is fairly simple and you can do what you are asking quite easily. When you are specifying the section access table in the script you will just need to use a little bit of script like this:

                                               

                                              Star is *;

                                              Section Access;

                                              Load * inline [

                                                   ACCESS, USERID, PASSWORD, COUNTRY

                                                   ADMIN, ztarique, ztarique,

                                                   USER, bob, bob, US

                                                   USER, bob, bob, GBR

                                                   USER, Jane, Jane, *

                                              ];

                                              Section Application;

                                               

                                              As you can see above you have the ACCESS column which shows what permission level (either ADMIN or USER) the user has, the USERID and PASSWORD columns which should be self explanatory, and the COUNTRY field which is your link from the section access table to the data (big NOTE: you need to make sure that the field and the values for the field linking section access to the data is all in UPPERCASE. Do this both in the section access table and the data itself).

                                               

                                              So, to explain:

                                              If you log in as yourself you will see everything as leaving it blank shows all values for the COUNTRY field.

                                              If you log in as bob you will see the data for the US and GBR countries.

                                              If you log in as Jane you will only see data for US and GBR countries.

                                               

                                              There is a noticeable difference between leaving a field blank and putting a star '*' in. A blank string will show all values, a star will only show all values that have been specified in the list. So, since we have only specified US and GBR this is all Jane will see.

                                               

                                              Adding an extra line for another country (e.g. MEX for Mexico) will mean that Jane will automatically be able to see Mexico data as well.

                                               

                                              I've attached an example document (I did this just to check what I was telling you was correct). Try logging in as the different users above.

                                               

                                              ONE LAST FINAL BIG BIG NOTE:

                                              Be very careful when you are playing around with section access as it can be too easy to lock yourself out of your application. Two suggestions to help you avoid that, either:

                                              1. Save a version without section access turned on (it doesn't matter if the table is still in the script as long as it isn't ticked in the document properties). Then you can use one of the copies to test your section access works.

                                              2. Section Access will apply the next time you open the QlikView document so you can leave your original document open with section access turned on and then open QlikView again and it will ask you to log in. If you can't get in you will still at least have the original document open.