Current selection alternatives -exclude selection

[#1]

Hi All,

Current Selection Alternatives

Hi all in the application shared for current selection alternative , if we want to omit some field from the current selection box.

Say in the qvw shared on above post if we want to remove the selection for Field four from Current selection straight table  as we have not mapped it..(.Straight Table with TextBetween....)

Do we have a way to do that?

Thanks

Khushboo

[swuehl · Accepted solution]

You should be able to exclude fields using set analysis, something like attached should work.

[marcus_sommer]

Current Selection Display

[Gabriel]

Hi,

If you are looking to hide fieldname from current selection box. What you can do is in the script

SET HidePrefix = %;

Then at the end of you script (in the case of attached .qvw) have a line as this

RENAME Field FieldFour to %FieldFour;

This will hide the field name from showing in current selection box. See below script

let vShowCS = 0;

SET HidePrefix = %;

Data:

LOAD * INLINE [

    FieldOne, FieldTwo, FieldThree, FieldFour

    1, A, Red, LOOONG

    2, B, Green, LOOONG

    3, C, Amber, LOOONG

    4, D, Blue, LOOONG

    5, E, Red, LOOONG

    6, F, Green, LOOONG

    7, A, Amber, LOOONG

    8, B, Blue, LOOONG

    9, C, Red, LOOONG

    10, D, Green, LOOONG

    11, E, Amber, LOOONG

    12, F, Blue, LOOONG

    3, B, Red, LOOONG

    1, D, Green, LOOONG

    2, E, Green, LOOONG

    3, F, Red, LOOONG

    4, A, Blue, LOOONG

    5, B, Amber, LOOONG

    6, C, Blue, LOOONG

    7, D, Amber, LOOONG

    8, E, Red, LOOONG

    9, F, Amber, LOOONG

    10, D, Green, LOOONG

    11, A, Green, LOOONG

    12, B, Red, LOOONG

];

FieldNameTranslation:

LOAD * INLINE [

    OldName, NewName

    FieldOne, Oans

    FieldTwo, Zwoa

    FieldThree, Zwoa

];

RENAME Field FieldFour to %FieldFour;

[#5]

Thanks a ton for the solution.

I was not using Aggr function, hence it was not working for me.

Khushboo

[thanstad]

Is it possible to get the Lock/Unlock and dropdown selection into the nice version of Current Selection above ?

/Tormod