Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I'm new to Qlik Sense
I added to a bar chart several alternate measures
how can I give a title to the chart depending on the selected alternative measure?
please advise
Hi Ali,
For dynamic titles ,you can write expressions under Appearance->general-> title.
I am not sure that can expression can help you with this, but if you can have an extension, you can do it for sure.
Thanks,
Sangram Reddy.
I know this but how to get the selected alternative measure; that's the question
Hi. I would also be interested in other's feedback on this. Other then creating an inline table and using conditional logic to select the dimensions (Can we change the dimension of a bar chart with a parameter in qlik sense?) has anyone implemented a different approach?
I haven't been able how to solve this one myself either.
Anyone? again the idea is that the title (even after a given starting text) on a chart gets automatically adjusted to the alternative measures when selecting them.
You can not do this for alternate measure or dimension.
but if it is necessary then you can create buttons with variable and then use that variable value in title.
Yes using a variable extension like QSVariable you can. See working example of this approach in attached App. Need to install QSVariable extension for it to work.
Hope this helps.
Andy
How to dynamically change the title:-
steps:-
Appereances---> General-------->Title---------->Expression
Title:-
='Sales per Category' & Sum(Sales)
Subtitle:-
='Overall sales' & Num( Avg(Sales),'#,0')
Footer:-
='Number of Customers' & Count(Customer)
Note:- I have shown the syntax how to dynamicaaly change titles, sub titles, footer
Notes:-
In my graph:-
Measure--- Sales(Sum)
DImension----Category
Here I have attached the image where you have to write the syntax to dynamically change the titles, subtitles, footer
i think recently added this feature in Qliksense
search youtube there is simple example explained by mike.
vivek provided as it is.