Select & Delete/Hide a value from List Box on Action of a Button - Help!!

[dmohanty]

Hi All,

I am loading some data into QVW from a QVD and displayed in a list box. Let the data looks like this -

User	Region
A	A1
A	A2
A	A3
A	A4
B	B1
B	B2
B	B3
C	C1
C	C2
C	C3
C	C4
C	C5

Suppose the User A logs-in and sees his data as A1, A2, A3, A4.

Requirement:

Now he wants to select some, let say A1 and A4 and want to Delete/Hide it from the List Box (remember, not required to delete from QVD), using the help of a Button.

Whenever he has to click on a Button, the selected values should go hidden and should not be loaded from QVD from next time on-wards too.

We might need any variable to be passed here - the selected values should be assigned a value in the variable and that value has to be taken care from next reload of qvd.

Could anyone help here please?

Message was edited by: Dicky Mohanty

[dmohanty]

Hi sudeepkmsudeepkm

Need some more help in implementing this. So attaching the sample QVW and QVD data source. Steps performed -

1. Loading the data source from the QVD.
2. The user has to select one value at a time from the Bookmark list box that he finds no longer relevant to him.
3. Once selected, he/she has to click on the Button to hide/delete that from GUI. I have tried doing it by passing it in a variable and storing that into a QVD called VariableTable.qvd
4. The corresponding Key is passed into the Variable. I am using Key to pass into variable, because the same Bookmark name might be available for any other user and that should not be deleted. Rather its corresponding Key has to be deleted for that USER.
5. Next time when the the QVW is reloaded again, the VariableTable.qvd is read to ignore the values those are filtered earlier, not to bring them into the QVW.
6. For this I have used two buttons - one with Macro and one without Macro. Both are working perfectly in Desktop mode, but in Access Point/ AJAX mode, its NOT working as expected. Seems the value is not being passed into the variable.

Could you please help here make this file work in AJAX mode? Any other possible solutions would help too - just like you have mentioned in you above reply.

Regards!

[petter]

The most straight forward way of getting the functionality that you describe is by using Bookmarks in QlikView.

A bookmark will store - per user - the selections being made. They can be applied on top of other selections - or not - your choice. They can be also be stored in the document instead of per user if you need it.

From what I understand of your requirements - bookmarks is the way to go.

[dmohanty]

Hi petter.skjolden‌,

For some reason, we are not using the bookmarks (documents are distributed across segment and they are lost the next day).

So was trying for some other alternatives.

[marcus_sommer]

have you tried my suggestions from above to use a filter-list which excluded those dimensions-values from all other listboxes and object-dimensions per variablen-control? For permanent using this approach you will need to store these variables within a bookmark - if bookmarks don't work you should at first look to find the reasons for this (maybe bookmarks are disabled within the application and/or the qmc-settings). Bookmarks are very useful in many situations therefore they should work.

Another possibility is my second suggestion to store those values within excel-files which the user exported to a certain storage. Similar to this is to use the export-actions which should work within the ajax-client too, see:

Also there is the possibility to change the client to the IE plugin for those special case.

- Marcus

[dmohanty]

Hi Marcus_Sommer‌,

Bookmarks we are not following - as the documents are reloaded on a daily basis and get distributed as per some segments/rules. So the Bookmarks are lost as per the segments.

IE Plugin is a good option - but unfortunately not followed at customer place.

I tried the Export Action option. I am successfully able to Export to a .TXT file from a click of the Button in the Desktop mode.

But in the AJAX mode/Access Point, the same click is opening up a new Tab/Window in browser with a list of values that are exported and not stored as a .TXT File.

Not sure Why - Exploring.

[marcus_sommer]

What are this for segments/rules which cause the lost of bookmarks - maybe there are potential to change and/or improve something?

The export within the webview worked without a popup-window but I think this couldn't be changed within the browser - it's a default behaviour from a browser to open everything from export, send to excel or printing in a popup-window.

I assume you (and your customer) will need to make some compromise or to rethink the whole task new.

- Marcus

[dmohanty]

Thank you Marcus_Sommer‌ for the explanation here.  Still trying for some other options.

Segments means they are just groups. Users are assigned to Groups based on their performances. If the User A is in Segment 1/Group 1 and he has applied some Bookmarks and tomorrow the QVW is refreshed and the same User A is moved to some other segment , say Segment 4, his all the Bookmarks are lost.

That's the reason they are not used.

[marcus_sommer]

I don't get it right up. The usergroup to which a user belonged to changed quite frequently? This meant the active- or custom-directory assigment to which then the applications are associated needs to be changed quite often? And otherwise the application itself is splitted into several applications? If so, why does another user(group)-application-matching and with them the lost of previous bookmarks matters somehow because if there are a splitting why should the user need those old views on the data?

Maybe a few more details will be helpful.

- Marcus