Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Title Bar - Display current selection & associtated data of a field

Hi All,

Can we display current selection value and associated value of a field in the Title Bar of Chart/Text box/Table?

Two examples in the below screen shot.

Title Bar.bmp

Suggestion / Solutions are most welcome !!!

Thanks

Gangadharan M

1 Solution

Accepted Solutions
Highlighted

Hi,

I'd use the Concat() functions to display the values selected or possible in each selection. In the first case, this should do in the caption, though:

='Year: ' & Max(Year) & ' Month: ' & Min(Month) & ' - ' & Max(Month)

The second case is not possible, since the functions used to return possible values don't go in that from-to way you are expecting unless you use two fields instead of one, of course. I'd use something like

='Year: ' & Max(Year) & ' Month: ' & Concat(DISTINCT Month)

That will return the list for all months possible, Jan, Feb, Mar, Apr, May, Aug and so on.

Hope that helps.

Miguel

View solution in original post

3 Replies
Highlighted

Hi,

I'd use the Concat() functions to display the values selected or possible in each selection. In the first case, this should do in the caption, though:

='Year: ' & Max(Year) & ' Month: ' & Min(Month) & ' - ' & Max(Month)

The second case is not possible, since the functions used to return possible values don't go in that from-to way you are expecting unless you use two fields instead of one, of course. I'd use something like

='Year: ' & Max(Year) & ' Month: ' & Concat(DISTINCT Month)

That will return the list for all months possible, Jan, Feb, Mar, Apr, May, Aug and so on.

Hope that helps.

Miguel

View solution in original post

Highlighted
Not applicable

Really awesome !!!

Thanks, Thanks a lot.

Highlighted
Partner
Partner

You can try GetCurrentSelections

Joaquin