Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

TextBox

Hi all

I have small doubt..

I have dimension like

Region

----------

North

south

east

west

so these values I want to display in text box   how can I do this?   Is there any specific function?

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Concat(Distinct  Region, ',')

This will give you comma separated values.

View solution in original post

10 Replies
tresesco
MVP
MVP

Concat(Distinct  Region, ',')

This will give you comma separated values.

soniasweety
Master
Master
Author

Nice  thank you

soniasweety
Master
Master
Author

And one more thing

Tresesco B

I want to load only  south,east from that field 

I want to load as optimized  how can I do ? I don't want to use where condition.?

tresesco
MVP
MVP

Try like:

filter: 

Load Filter Inline [

Filter

south

east

];

Load

          Region

From <qvd path> where exists(Filter, Region);

Drop table filter;

soniasweety
Master
Master
Author

Ohh if I use exists function it is optimized?

tresesco
MVP
MVP

Yes, it is still optimized. Read this: qlikview-optimised-qvd-loads

soniasweety
Master
Master
Author

thanks I will go through it 

soniasweety
Master
Master
Author

its giving page not displayed

tresesco
MVP
MVP

It's an active page. Possibly your network is restricting it. Please check.