Selections to be deleted/hidden from List Box in Reports on Access Point (AJAX mode) - HOW?

[dmohanty]

Hi All,

Have a requirement, where User can delete some of the values from a List Box, which he finds no more relevant. May be just upon selection of that value or using a button after selection.

Have tried multiple ways - Macro, Passing the value into variable, exporting the selected values into QVD/Excel etc. etc. - All working fine in Desktop Mode, but none of them working in AJAX Mode.

The data that User is going to delete, that is confined to that user and not available for other users. This has been restricted using Section Access.

Any possible help - How to remove values from QVWs available on Access Point in AJAX Mode?

[Peter_Cammaert]

I didn't mean that you yourself should provide the values to be filtered out, the end-user can do that.

You said in your OP that you tested the export of values in a QVD/Excel. A listbox can be easily exported by an AJAX user into an existing excel on a file share (optionally only accessible to that user). The next document reload can be made to pick up all values in one or more excel files (one per end-user) and include them in a section access reduction scheme. Should work fine.

No intervention from the developer or the QlikView administrator is needed. End-users manage the whole cycle.

Best,

Peter

[villegasi03]

I agree with Pete.

Also you could try to add an expression in the list box. Something like this might work (didn't test it but might work to filter your list)

if(MAIN_LIST_VALUES <> GetFieldSelections(VALUES_TO_EXCLUDE), MAIN_LIST_VALUES ) .

VALUES_TO_EXCLUDE field is the same as MAIN_LIST_VALUES but just given a different name in the script. Might not even need to do that though.

[dmohanty]

OK pcammaert‌,

I tried doing that too- But not supporting in AJAX

• One by Export to QVD using Macro -

sub ChartToQVD

    set obj = ActiveDocument.GetSheetObject("CH01")

    obj.ExportEx "BookmarkExportQVD.qvd", 4

end sub

• The other is Export using Action