topic Re: ValueList in QlikView

ValueList

Wed, 25 Nov 2020 16:16:04 GMT

I'm trying to create a conditional valuelist dimension. There is an error in my expression but the program does not indicate where. What is wrong?

//SubStringCount(Concat(_metricsNo, '|'), 1) outputs the number 1- I have tested this.

=ValueList(If(SubStringCount(Concat(_metricsNo, '|'), 1)=1,'Pr'),
If(SubStringCount(Concat(_metricsNo, '|'), 2),=1'Be'),
If(SubStringCount(Concat(_metricsNo, '|'), 3)=1,'LR'))

Thank you!

Re: ValueList

sunny_talwar — Fri, 24 Jun 2016 20:08:21 GMT

May be you need this:

If(GetSelectedCount(_metricsNo) > 0, Pick(_metricsNo, 'Pr', 'Be', 'LR'))

Re: ValueList

sunny_talwar — Fri, 24 Jun 2016 20:09:08 GMT

If this is not what you need, would you be able to share a sample with your expected output?

Re: ValueList

Fri, 24 Jun 2016 20:12:15 GMT

This is the relevant script.

Metrics:
LOAD * INLINE [_metricsNo, _metrics
1, Pr
2, Be
3, LR

If _metricNo 1 field is selected, the value list should include the string 'Pr'

Re: ValueList

swuehl — Fri, 24 Jun 2016 21:06:05 GMT

I am not quite sure what you are trying to achieve, ,maybe just use _metrics as dimension?

=ValueList(

$(=chr(39)&Concat(DISTINCT _metrics, Chr(39)&','&chr(39), _metricsNo) &chr(39))

)