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: 
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.