Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Alternate States - Use field from select state as name of a column

Hi,

I created two state Test1 and Test2

also two multi box that link to each state and they have fields of Month, Year and etc.

I want that name of column in straight table will be as I selected in specific state. For example in multi box that link to Test1 I selected March as month So the name in the column will be Month March.

Thanks,

1 Solution

Accepted Solutions
sunny_talwar

Mya be create the column label as this:

Only({Test1} Month)

or use concat if you would want to show multiple selections

Concat({Test1} Month, ', ')

View solution in original post

6 Replies
vikasmahajan

Like this  ?

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Anonymous
Not applicable
Author

Hi,

No i have two multi box that link to alternate stat test1 and test2

I want that a name of a column will be according what i change in the multi box.

for example:

in multi box object i selected in month Field : May.

So in the column in the table will be according to the selection in multi box that link to alternate stat test1

I hope that i was more clear.

Thanks for any helpUntitled.png

vikasmahajan

How you will assign multiples states into multi box , i think you need to create a list box instead of multi box

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Anonymous
Not applicable
Author

there is two multi box which each one of them link to different alternate state.

because i link it i can get multiples state for example different month

sunny_talwar

Mya be create the column label as this:

Only({Test1} Month)

or use concat if you would want to show multiple selections

Concat({Test1} Month, ', ')

Anonymous
Not applicable
Author

Thanks