Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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
Highlighted

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
Highlighted

I would suggest doing this in the script...

Fact:

LOAD MonthsValue,

     ...

From ....;

BridgeTable:

LOAD MonthsValue,

     SubField(MonthsValue, ',') as LIST_MONTH

Resident Fact;

Highlighted
Champion
Champion

Hi,

Try this:

Concat(DISTINCT LIST_MONTH,',')

Good luck

YB

Highlighted
Contributor III
Contributor III

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

Highlighted

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

Contributor III
Contributor III

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