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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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