topic Re: Listbox with a column with multiple choices in QlikView

Listbox with a column with multiple choices

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Thanks

Re: Listbox with a column with multiple choices

sunny_talwar — Mon, 25 Sep 2017 15:42:39 GMT

I would suggest doing this in the script...

Fact:

LOAD MonthsValue,

...

From ....;

BridgeTable:

LOAD MonthsValue,

SubField(MonthsValue, ',') as LIST_MONTH

Resident Fact;

Re: Listbox with a column with multiple choices

YoussefBelloum — Mon, 25 Sep 2017 15:46:10 GMT

Hi,

Try this:

Concat(DISTINCT LIST_MONTH,',')

Good luck

Re: Listbox with a column with multiple choices

Anonymous — Mon, 25 Sep 2017 15:50:42 GMT

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

Re: Listbox with a column with multiple choices

sunny_talwar — Mon, 25 Sep 2017 16:20:30 GMT

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;

Re: Listbox with a column with multiple choices

Anonymous — Mon, 25 Sep 2017 16:58:50 GMT

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