Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
bruno_m_santos
Partner - Creator
Partner - Creator

Concatenate Variables

Hi guys,

I need to concatenate two variables: vMeasure and vState.

Do you know how to do it?

Many Thanks

Bruno

My Expression:

=Count(
{
Concat('$(vMeasure) $(vState)',)
}
DISTINCT
Units)

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Oh, right, Bookmarks. Didn't read correctly. My mistake.  Try this then:

count({ $(vMeasure) + $(vState) } distinct Units)

....or do your variables contain more than one bookmark per variable?


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

try count( $(vMeasure)&$(vState) distinct Units)


talk is cheap, supply exceeds demand
bruno_m_santos
Partner - Creator
Partner - Creator
Author

Hi Gysbert,
Thanks but doesn´t work.
My Variables have bookmarks, that are triggered by buttons.
At the end I need a expression like this.
Thanks
Bruno

=Count(
{ [Consultas]+ [Realizado]
}
DISTINCT

UNITS)

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Oh, right, Bookmarks. Didn't read correctly. My mistake.  Try this then:

count({ $(vMeasure) + $(vState) } distinct Units)

....or do your variables contain more than one bookmark per variable?


talk is cheap, supply exceeds demand
bruno_m_santos
Partner - Creator
Partner - Creator
Author

I had just found the error. You are absolutely right.

Many Thanks

Bruno