How to get selected value of field in Script ??

[nikhilgarg]

How to get selected value of field in Script ??

I tried GetCurrentField[FiscalYear] ; but it does not work out.

Thanks

[nikhilgarg]

Yup,

YOu are ryt. It is expression actually in caption of straight table.

[nikhilgarg]

Thanks,

first option works.

[Anonymous]

if your field can have multiple values selected at the same time then you can use

concat(FiscalYear,'|')

[nikhilgarg]

Hey ,

Thanx but can you please give an example

[Anonymous]

Please find the attachment

[nikhilgarg]

Hey,

I am using Personal Edition of Qlikview Desktop, so can not open your document. Can you please tell me what you ahve writte in expression?

[Anonymous]

Below are the three text objects I have created and 2 inline tables in the script

='Only _dimensions Possible values '&Concat(_Dimension,'|')

='All current selections '&GetCurrentSelections(_Dimension)

='Only _Dimensions Current Selection '&GetFieldSelections(_Dimension)

And 2 list boxes to see effect on selctions

usedDimensions:

LOAD * INLINE [

    _Dimension

    Country

    Area

    Region

];

userFacts:

LOAD * INLINE [

    _fact

    Salesqty

    SalesPrice

];