Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

a0m18zz
New Contributor

How to make sort by category and view by default in QV-9 accesspoint

If you open QV-9 SR5 accespoint all the accespoint document will show up as "Thumbnails" but we would like it to appear by default as "detail" for all user--Is is possible to do in system level?

If you open QV-9 SR5 accespoint all the accespoint document will show up as sor by "name" but we want it should be sory by "category" by default for all user--Is is possible to do in system level?

7 Replies
Not applicable

How to make sort by category and view by default in QV-9 accesspoint

No you can´t change this on a system level, this is to make it possible for each user to create their own view, as always the latest selection is the one shown the next time you open your Access Point.

vgutkovsky
Honored Contributor II

How to make sort by category and view by default in QV-9 accesspoint

Yes you can. See my post here: http://community.qlik.com/forums/p/24667/94637.aspx, that should do the trick.

Regards,

Not applicable

How to make sort by category and view by default in QV-9 accesspoint

I know this post is kind of old, but I'm trying to do what you say is possible.  However, when I try to follow your link I don't get anywhere.  Can you please point me in the correct direction of how this is possible.  Thanks.

bnichol
Valued Contributor

How to make sort by category and view by default in QV-9 accesspoint

You can modify the the HTML and Java Script files used to create the default the AccessPoint page, but as ako indicated previously the individual users settings will be updated as they make changes.

To ensure that these setting are always used, you should set the value in the js file and remove the drop-down boxes to on the HTML page.

To set the view to details:

Change the C:\Program Files\QlikView\Web\QvAccessPoint.js ...

//    var view = node.getAttribute("view");

    var view = "Details";

Remove the following code from C:\Program Files\QlikView\Web\index.htm...
                <td><span avq=".View_text">View</span>: <select avq="edit:.View"></select></td>

Good luck,

B

gidde
New Contributor

How to make sort by category and view by default in QV-9 accesspoint

Hi!

I have the same problem and have now solved the first step (thanks) but how do I change the sort order?

Not applicable

How to make sort by category and view by default in QV-9 accesspoint

Hi,

I solved this problem in QV10-Accesspoint by setting the cookies for the two dropdowns.

Set this code before Qva.Start() in the QlikView\Web\index.htm:

var eDate = new Date();

eDate = new Date(eDate.getTime() + 1000*60*60*24*1);

document.cookie = "View=Details;path=/QvAJAXZfc/;expires="+eDate.toGMTString()+";";

document.cookie = "SortBy=Category;path=/QvAJAXZfc/;expires="+eDate.toGMTString()+";";

It sets the expire-date of the cookies to the next day. Because the original cookie is valid for one year, it has the first priority and if the user changes the settings, these are taken the next time they open the ap. If you don't want this, set the expire-date from +1 day to greater than one year.

If you do so, you should possibly remove the two dropdowns by deleting the following code in the QlikView\Web\index.htm:

<td><span avq=".SortBy_text">Sort by</span>: <select avq="edit:.SortBy"></select></td>

<td><span avq=".View_text">View</span>: <select avq="edit:.View"></select></td>

gidde
New Contributor

How to make sort by category and view by default in QV-9 accesspoint

Thanks, appreciate it!

Community Browser