topic Re: Mashup table sort option in Integration, Extension & APIs

Mashup table sort option

feg — Sat, 16 Nov 2024 02:47:10 GMT

Hi all,

I created a table in QlikSense and use its hypercube to render it in a mashup.

I would like to add the sort functionality, so that if I click on the measure header it sort the table.

I tried with "setOptions()" and "backendApi.applyPatches()" but I do not seem to be able to make it work.

Can you help me?

Re: Mashup table sort option

ErikWetterberg — Mon, 06 Apr 2020 05:37:10 GMT

Hi,

I have written about this on my blog:

https://extendingqlik.upper88.com/guide-to-qlik-sense-applypatches/

There is also a link to a more complete example, that I showed at Qonnections in 2015, available on GitHub.

Hope this helps!

Re: Mashup table sort option

feg — Mon, 06 Apr 2020 07:09:57 GMT

Hi @ErikWetterberg ,

thanks for your help, I can now change the column sort using the "applyPatches".

I'm having an issue with the "reversesort', when I call it it gives me an error "reversesort is not defined". Infacact I can not see that in the console. What am I doing wrong?

Re: Mashup table sort option

feg — Tue, 07 Apr 2020 00:41:39 GMT

I found this method of the capability API.

https://help.qlik.com/en-US/sense-developer/February2020/Subsystems/APIs/Content/Sense_ClientAPIs/CapabilityAPIs/TableAPI/QHeader.htm

They seems to work nicely and they are much easier to implement.

Why should I use applyPatches instead?

Re: Mashup table sort option

ErikWetterberg — Tue, 12 May 2020 03:36:16 GMT

If they cover your need, go ahead and use them instead.