Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
diffeyj
Partner
Partner

Set chart window title to first sorted column

I have a fairly "standard" straight table. It has a single dimension and a number of expressions around Sales.

diffeyj_0-1591681338499.png

I want the Window Title to update as the user changes the sort order. So if the user sorts on cost then I want it to say 'YTD Sales Analysis by Cost', and when they select Margin, it should say 'YTD Sales Analysis by Margin'.

Is there any function that can get the label for the first column (dimension or expression) in the Sort Priority? 

diffeyj_1-1591681422344.png

 

Labels (3)
1 Solution

Accepted Solutions
lironbaram
Partner
Partner

hi 

i don't think this option is available, 

one way you can achieve this create a field with the list of measures in the table 

and give the user option to select one

than sort the table by the dimension and sort the dimension by expression which will change according to the selected measure 

then you'll be able also to select the title by using the selected value 

View solution in original post

1 Reply
lironbaram
Partner
Partner

hi 

i don't think this option is available, 

one way you can achieve this create a field with the list of measures in the table 

and give the user option to select one

than sort the table by the dimension and sort the dimension by expression which will change according to the selected measure 

then you'll be able also to select the title by using the selected value 

View solution in original post