Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikssewarrior
Contributor II
Contributor II

QlikSense - Accessing source data table in a custom extension

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!  

Labels (5)
1 Reply
abhijitnalekar
Specialist II
Specialist II

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.

 

 

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!