Impromptu - Picklist values

[GilMerc]

Hi,

I use a pickList with a multiple values. I use it for for prompt and it works very well. When I show it directly in a header, for example, it works good but when I want to show it in a calculation field, for example I want concatenate the values with an other, the picklist lost a multiple values and I can select one choice only.

Somebody know, if I have a solution.

Thanks, Gilles.

 

[sln007]

You are referring to a 'numeric' values pick-list??

 

[griffindm]

Gilles,

This happens when there is some usage of the picklist prompt that is does not use the IN comparison. There have been some reports here of this also happening without a direct cause in Impromptu 7.0. See the Impromptu Prompt FAQ for more information.

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[GilMerc]

Dave,

Does it mean, I can't refering a content of a picklist?
I use a picklist like Impromptu Prompt FAQ explain but in some situation I want a content, for example I take a comparaison like that :
if ('' in picklist) than '' else picklist

The second use of picklist affect a multiple value, is it exact?
If yes, can I have a workaround?

Gilles.

 

[griffindm]

Gilles,

It means that you cannot have both an expression that uses the prompt with an IN clause, and another that uses any other comparison, i.e. &quot;=&quot; &quot;<>&quot;, or any other type. If you use anything comparison other than IN, your prompt collapses to a single selection.

Dave Griffin


Dave Griffin

The Decision Support Group
Reporting Consulting with Cognos BI Tools
&quot;Magic with Data&quot;
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com