Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You should be able to exclude fields using set analysis, something like attached should work.
You should be able to exclude fields using set analysis, something like attached should work.
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;
Thanks a ton for the solution.
I was not using Aggr function, hence it was not working for me.
Khushboo
Is it possible to get the Lock/Unlock and dropdown selection into the nice version of Current Selection above ?
/Tormod