Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Current selection alternatives -exclude selection

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

View solution in original post

5 Replies
swuehl
MVP
MVP

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

View solution in original post

marcus_sommer
MVP & Luminary
MVP & Luminary

Gabriel
Partner
Partner

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;

Not applicable
Author

Thanks a ton for the solution.

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

Khushboo

thanstad
Creator
Creator

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


/Tormod