topic Re: Select & Delete/Hide a value from List Box on Action of a Button - Help! in QlikView

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

dmohanty — Fri, 18 Sep 2015 14:29:21 GMT

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

Re: Select & Delete (Hide) a value from List Box on Action of a Button - Help!

marcus_sommer — Fri, 18 Sep 2015 14:46:22 GMT

If the user could store and reload the application then you need to build from those selections a variable which would be used as where-clause within the load-statement, something in this way:

vWhere: not match(Region, $(=getfieldselections(Region, ', ')))

If the user couldn't store (working per access point) you will need some strategy to store those selections externally, maybe per macro in a text-file or per https://community.qlik.com/search.jspa?q=write+back&type=document.

- Marcus

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

sudeepkm — Fri, 18 Sep 2015 14:53:56 GMT

May be section access. The section access logic table can contain the field values that user does not want to see on the Dashboard. At the time of reload it can be taken care. Any time they want their data back they just need to modify the records in Section Access logic table and reload the document.

Managing the values what they want to see or not will be in the Section Access logic table that could be available in a DB table or spreadsheet.

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

dmohanty — Fri, 18 Sep 2015 15:53:00 GMT

Hi Marcus,

I agree with your second point - If the user couldn't store (working per access point)

The user has just to access the report from Access Point >> Select few values from List Box >> Click on a Button to delete or hide and he won't see further. Even though the value is available in the QVD, these won't be reloaded into the document next reload on-wards.

Any help here?

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

dmohanty — Fri, 18 Sep 2015 16:02:34 GMT

Hi Sudeep,

This suggestion will be difficult to maintain I guess. There are not 1 or 2 or 10 values - There might be 100 of values from the List Box , that the user want to remove. Maintaining those in Section Access will be difficult.

Also, they don't have access to Section Access script to modify.

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

marcus_sommer — Fri, 18 Sep 2015 17:42:49 GMT

For me it's not quite clear what is aimed with those deleting/hiding but I think it should be at first to solve this with rather practically approaches before starting a complex developing-task, maybe in this way:

- listboxes and dimensions in object are calculations which only showed values which aren't in a variable like vDataReducing which will be filled with the getselection values from those fields and which is be triggered from this button - this alone could be already enough

- in another chart is the opposite from them and this will be per the same button exported into a network-store which the load-routines from this application read in a loop each time and created from them a distinct filter for a where-clause

- Marcus

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

dmohanty — Fri, 18 Sep 2015 19:00:03 GMT

Hi Marcus_Sommer‌

The reason for User being removing the values is - there are some values which are gone Obsolete and User only wants to remove them or hide them. Developer don't have rights to remove them from QVD.

From the list box itself, user will decide, which values he has to remove.

So wanted a similar solution like - whatever the values he selects and clicks button, those will be assigned with a Variable Value and will be remembered whenever next time it is reloaded.

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

sudeepkm — Fri, 18 Sep 2015 19:46:39 GMT

Understood. One quick question what about multi user interaction. If one user marked a value to be removed from the data set and at the other hand the other user needs it.

I think your requirement is to have a solution on the UI to hide those selected values immediately and then not to consider those values while reloading data next time.

As Marcus suggested you need to explore more on the Write back capability. This is how I would recommend designing the solution.

1. Create a new field like a flag at your data source such as "Val_Ignore"

2. Use where clause to ignore records where Val_Ignore = 'YES' (better to use number such as 0 or 1)

3. Use write back solution on the UI (one example is here Free Text Box Extension Object) using which users can select the particular value that they do not want to get reloaded next time. using this write back users will set Ignore to the record.

4. Now the question is how soon that change should get reflected in the UI which depends upon the data refresh. You may consider using Partial reload for this table which will support higher frequency load without causing to run the script for other tables in the same qvw script.

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

Fri, 18 Sep 2015 20:04:04 GMT

You can create an object (button ou text box) and add an action "select excluded" for the field (Region).

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

dmohanty — Tue, 22 Sep 2015 00:02:30 GMT

Hi sudeepkm,

You understood the requirement correctly. To handle the Multi User problem, we have Section Access and any user can remove any values that belongs only to him (may be corresponding ID/Key has to be removed). So there is no issue if any value is hidden immediately and then not to consider those values while reloading data next time.

Could you show me with a sample app please what you have explained?

I actually tried in two steps in a Button -

Select Excluded field
Then apply a Macro (Which is not working in AJAX mode)

SUB AfterReload

ActiveDocument.ReduceData

END SUB

Regarding the refresh of the data/QVW - it happens daily once. If the User selects are hides the values from the List box (and it has to be stored in Variable or any Flag field), then the next day the QVW has to be reloaded using Where clause, not to bring that value into the field.

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

dmohanty — Tue, 22 Sep 2015 04:28:54 GMT

Hi sudeepkm sudeepkm

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

Loading the data source from the QVD.
The user has to select one value at a time from the Bookmark list box that he finds no longer relevant to him.
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
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.
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.
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!

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

petter — Tue, 22 Sep 2015 05:42:01 GMT

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.

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

dmohanty — Tue, 22 Sep 2015 11:46:15 GMT

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.

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

marcus_sommer — Tue, 22 Sep 2015 13:31:42 GMT

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

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

dmohanty — Tue, 22 Sep 2015 15:48:37 GMT

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.

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

marcus_sommer — Tue, 22 Sep 2015 16:13:27 GMT

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

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

dmohanty — Tue, 22 Sep 2015 16:36:28 GMT

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.

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

marcus_sommer — Tue, 22 Sep 2015 18:56:21 GMT

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