Expression Results Help

Thu, 18 Mar 2010 09:44:17 GMT

Hi Folks

I have an expression as follows:

=if(Index(GetFieldSelections("ColName"),'Dim1') , 1 , 0 )

This is being used to control the conditional show of a column in a straight table, the expression works fine when only a few selections are made, but when many selections are made it doesn't work. This is because the result of GetFieldSelections("ColName") changes from a list of selections to a list of not selected:

EG:

Result 1 = Dim1 , Dim2, V1, V2, V3

But Result 2 Could be = NOT Dim5, Dim6, V4

So, what would be the best way to change the expression so that it works 100% of the time, and I would if possible like to avoid using macros to achieve this.

Any help greatly appreciated.

Expression Results Help

Thu, 18 Mar 2010 19:00:09 GMT

Hy,

Try the Maxvalues option in the formula.

It's only when the count gets near or above Maxvalues that QV starts using "NO..." or "ALL".

GetFieldSelections("AA",',',999)

Greetings,

Piet

Expression Results Help

Fri, 19 Mar 2010 08:09:03 GMT

Hello Piet

Thanks very much, exactly what I was looking for.

Cheers,

topic Expression Results Help in QlikView

Expression Results Help

Expression Results Help

Expression Results Help