topic Re: Current selection alternatives -exclude selection in QlikView

Current selection alternatives -exclude selection

Wed, 30 Sep 2015 08:14:08 GMT

Hi All,

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

Re: Current selection alternatives -exclude selection

swuehl — Wed, 30 Sep 2015 08:52:22 GMT

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

Re: Current selection alternatives -exclude selection

marcus_sommer — Wed, 30 Sep 2015 09:54:57 GMT

Current Selection Display

Re: Current selection alternatives -exclude selection

Gabriel — Wed, 30 Sep 2015 10:09:22 GMT

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;

Re: Current selection alternatives -exclude selection

Wed, 30 Sep 2015 10:56:52 GMT

Thanks a ton for the solution.

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

Khushboo

Re: Current selection alternatives -exclude selection

thanstad — Fri, 30 Oct 2015 11:35:39 GMT

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

/Tormod