Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to get semicolon in qlikview

Hi

My sources like below

  

TitleTypeContact
ChinaFTripFrederik Thaseomn
ChinaFTripErik Kovacs

I am excapated o/p is

Title              Type          Contact

China            FTrip            Frderik Thaseomn;Erik Kovacs

thanks,

NAni

1 Solution

Accepted Solutions
tresesco
MVP
MVP

May be, you don't need count() here. Try like:

=Concat({<[Event Date]={">=$(=Date(vStartDate,'MM/DD/YYYY'))<=$(=Date(vEndDate,'MM/DD/YYYY'))"}>} DISTINCT [Contact] ,';')

View solution in original post

8 Replies
tresesco
MVP
MVP

Use separator ';' with concat(), like:

=Concat( Distinct Contact, ';' )

Chanty4u
MVP
MVP

may be this?

Concat(distinct Contact,';') as new

Anonymous
Not applicable
Author

hi Tresesco,

I tried,It's not wprking

Thanks,

tresesco
MVP
MVP

Tried with straight table like below ?

Capture.JPG

Anonymous
Not applicable
Author

Hi

i applied same in my application it's not working see below my expression

=count({<[Event Date]={">=$(=Date(vStartDate,'MM/DD/YYYY'))<=$(=Date(vEndDate,'MM/DD/YYYY'))"}>}Concat(DISTINCT[Contact],';'))

tresesco
MVP
MVP

May be, you don't need count() here. Try like:

=Concat({<[Event Date]={">=$(=Date(vStartDate,'MM/DD/YYYY'))<=$(=Date(vEndDate,'MM/DD/YYYY'))"}>} DISTINCT [Contact] ,';')

Anonymous
Not applicable
Author

hi

=Concat({<[Event Date]={">=$(=Date(vStartDate,'MM/DD/YYYY'))<=$(=Date(vEndDate,'MM/DD/YYYY'))"}>} DISTINCT [Contact] ,';')

After trying above expression getting o/p below like this:

TitleTypeContact
ChinaFTripFrederik Thaseomn
ChinaFTripErik Kovacs

I am excapated o/p is

Title              Type          Contact

China            FTrip            Frderik Thaseomn;Erik Kovacs

Anonymous
Not applicable
Author

Thank you so much

It's woking fine.

Thanks,

Nani