Set chart window title to first sorted column

diffeyj — Sat, 16 Nov 2024 18:31:09 GMT

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

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?

Re: Set chart window title to first sorted column

lironbaram — Tue, 09 Jun 2020 06:46:36 GMT

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

topic Re: Set chart window title to first sorted column in QlikView

Set chart window title to first sorted column

Re: Set chart window title to first sorted column