Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Listbox with a column with multiple choices

Hi!

I am fairly new with Qlikview, so my question might be simple ...

I have a list box contaning the months (field LIST_MONTH), January, February, etc.

I have a column called MonthsValue, that could contains one month, or many months , like "March,September,October", Comma separated. What would be the expression to be able to get the list of the selected months ...

Test-Month.png

Thanks

1 Solution

Accepted Solutions
sunny_talwar

And that is exactly why I didn't touch your Fact table... It is retained as is and without any duplication of rows. Any duplication done is within the BridgeTable... which should not really have a huge negative impact... only change is that I would add DISTINCT to the BridgeTable Load

BridgeTable:

LOAD DISTINCT MonthsValue,

    SubField(MonthsValue, ',') as LIST_MONTH

Resident Fact;

View solution in original post

5 Replies
sunny_talwar

I would suggest doing this in the script...

Fact:

LOAD MonthsValue,

     ...

From ....;

BridgeTable:

LOAD MonthsValue,

     SubField(MonthsValue, ',') as LIST_MONTH

Resident Fact;

YoussefBelloum
Champion
Champion

Hi,

Try this:

Concat(DISTINCT LIST_MONTH,',')

Good luck

YB

Anonymous
Not applicable
Author

I would like to retain the fact that I have one row per Type ...

sunny_talwar

And that is exactly why I didn't touch your Fact table... It is retained as is and without any duplication of rows. Any duplication done is within the BridgeTable... which should not really have a huge negative impact... only change is that I would add DISTINCT to the BridgeTable Load

BridgeTable:

LOAD DISTINCT MonthsValue,

    SubField(MonthsValue, ',') as LIST_MONTH

Resident Fact;

Anonymous
Not applicable
Author

Thanks , works like a charm... I am amazed .. still a lot to learn in Qlikview ...