Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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
Highlighted
MVP
MVP

Re: How to get semicolon in qlikview

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
Highlighted
MVP
MVP

Re: How to get semicolon in qlikview

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

=Concat( Distinct Contact, ';' )

Highlighted
Champion III
Champion III

Re: How to get semicolon in qlikview

may be this?

Concat(distinct Contact,';') as new

Highlighted
Contributor
Contributor

Re: How to get semicolon in qlikview

hi Tresesco,

I tried,It's not wprking

Thanks,

MVP
MVP

Re: How to get semicolon in qlikview

Tried with straight table like below ?

Capture.JPG

Highlighted
Contributor
Contributor

Re: How to get semicolon in qlikview

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],';'))

Highlighted
MVP
MVP

Re: How to get semicolon in qlikview

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

Highlighted
Contributor
Contributor

Re: How to get semicolon in qlikview

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

Highlighted
Contributor
Contributor

Re: How to get semicolon in qlikview

Thank you so much

It's woking fine.

Thanks,

Nani