Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to get selected value of field in Script ??
I tried GetCurrentField[FiscalYear] ; but it does not work out.
Thanks
Yup,
YOu are ryt. It is expression actually in caption of straight table.
Thanks,
first option works.
if your field can have multiple values selected at the same time then you can use
concat(FiscalYear,'|')
Hey ,
Thanx but can you please give an example
Please find the attachment
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?
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
];