Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
nani1990
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
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

nani1990
Contributor
Contributor
Author

hi Tresesco,

I tried,It's not wprking

Thanks,

tresesco
MVP
MVP

Tried with straight table like below ?

Capture.JPG

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

nani1990
Contributor
Contributor
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

nani1990
Contributor
Contributor
Author

Thank you so much

It's woking fine.

Thanks,

Nani