QlikSense - Accessing source data table in a custom extension

qlikssewarrior — Mon, 27 Sep 2021 18:52:51 GMT

Hello all!

I am facing a little challenge trying to figure out the best approach for solving this problem. I have a QS custom extension that accesses the source data via measures and dimensions (feeding X & Y axis data in my custom chart control). All of this works fine, however, I also have a lookup table in my source data that has a list of all available measures and dimensions, and corresponding metadata for each measure (like "Friendly Name" etc.) What is the best way to access this lookup table in my custom extension code? Ideally, I'd like the ability to query this lookup table in the extension code to get the list of metadata for the selected measure and dimension. I need to look this metadata up every time the user configures the measure or the dimension for the custom extension.

Thanks!

Re: QlikSense - Accessing source data table in a custom extension

abhijitnalekar — Tue, 28 Sep 2021 12:51:28 GMT

Hi @qlikssewarrior

Can you please try below formula

=$(=FirstSortedValue([Dimension] ,[Dimension Position],1)) in Field and

=FirstSortedValue([Dimension Name] ,[%Dimension Position],1) in Lable

Hope this help you to get the desire output.

topic Re: QlikSense - Accessing source data table in a custom extension in Integration, Extension & APIs

QlikSense - Accessing source data table in a custom extension

Re: QlikSense - Accessing source data table in a custom extension