topic Re: How to get selected value of field in Script ?? in QlikView

How to get selected value of field in Script ??

nikhilgarg — Thu, 26 Mar 2015 14:17:04 GMT

How to get selected value of field in Script ??

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

Thanks

Re: How to get selected value of field in Script ??

its_anandrjs — Thu, 26 Mar 2015 14:20:06 GMT

Try With

=Getfieldselections( [FiscalYear] )

Regards

Anand

Re: How to get selected value of field in Script ??

northerner — Thu, 26 Mar 2015 14:20:32 GMT

Hi Nikhil,

GetCurrentField works on groups - the parameter should be a group name. It does not operate on fields (the function name is not particularly clear)

Have you looked at the syntax for getfieldselections()?

Hope this helps!

Re: How to get selected value of field in Script ??

Ralf-Narfeldt — Thu, 26 Mar 2015 14:45:41 GMT

GetCurrentField can't be used in a script.

It can only be used in chart expressions in the UI.

Re: How to get selected value of field in Script ??

nikhilgarg — Thu, 26 Mar 2015 14:46:01 GMT

Hey,

It works but now i want if nothing is selected in _CalendarType then SalesBookUsage should be visible in straight table caption. How can i acheive this??

My script is:

If(_CalendarType = 'Fiscal' , GetFieldSelection([Fiscal Year])).

thanks

Re: How to get selected value of field in Script ??

nikhilgarg — Thu, 26 Mar 2015 14:46:53 GMT

Hey,

It works but now i want if nothing is selected in _CalendarType then SalesBookUsage should be visible in straight table caption. How can i acheive this??

My script is:

If(_CalendarType = 'Fiscal' , GetFieldSelection([Fiscal Year])).

thanks

Re: How to get selected value of field in Script ??

its_anandrjs — Thu, 26 Mar 2015 14:51:02 GMT

Hi,

Use variable here try dynamically store the SalesBookUsage value in the variable and then use it here in the variable.

Ex:-

If(_CalendarType = 'Fiscal' , GetFieldSelection([Fiscal Year]), $(vSalesBookUsgae) ).

Also it does not seems your expression works in getfieldslection condition check once but you deleted the eariler messsage on that i explain the correct way to use the getfieldselections().

Ex:- Like this ways

if( GetFieldSelection(_CalendarType) = 'Fiscal' , ([Fiscal Year]), $(vSalesBookUsgae) )

Regards

Anand

Re: How to get selected value of field in Script ??

nikhilgarg — Fri, 27 Mar 2015 08:06:51 GMT

Hey ,

Thanx anand but still my problem is not solved.

My expr is like:

=if(_CalendarType = 'Fiscal' , GetFieldSelections([Trade Fiscal Year]) & '-' & GetFieldSelections([Trade Fiscal Quarter]) ,

if(vTradeCalendarDateType = '1D' , date(max({1}TradeDateMaster), 'MM/DD/YYY') , $(vSalesbookUsage))

) Now when i select any date, in my table caption date is visible but when i clear everything then still last selected date is there. But i want when i clear everything , SalesbookUsage should be visible.

What to do??

Re: How to get selected value of field in Script ??

Peter_Cammaert — Fri, 27 Mar 2015 08:16:57 GMT

Nikhil,

you're talking about expressions, not about any script. With script, people refer to the load script as presented in the script editor (File->Edit Script...) That's an entirely different ball game.

Re: How to get selected value of field in Script ??

Peter_Cammaert — Fri, 27 Mar 2015 08:23:30 GMT

BTW try this expression:

If (_CalendarType = 'Fiscal' , GetFieldSelection([Fiscal Year]), if (GetSelectedCount(_CalendarType) = 0, $(vSalesBookUsage)))

If SalesBookUsage is a field (i.e. an Amount) put an aggregation expression in vSalesBookUsage, like

SET vSalesBookUsage = 'Sales Book Usage = ' & sum(SalesBookUsage);

or define something similar in the Variable Overview.

Best,

Peter

Re: How to get selected value of field in Script ??

nikhilgarg — Fri, 27 Mar 2015 08:33:57 GMT

Yup,

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

Re: How to get selected value of field in Script ??

nikhilgarg — Fri, 27 Mar 2015 08:40:12 GMT

Thanks,

first option works.

Re: How to get selected value of field in Script ??

Anonymous — Fri, 27 Mar 2015 09:05:09 GMT

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

concat(FiscalYear,'|')

Re: How to get selected value of field in Script ??

nikhilgarg — Fri, 27 Mar 2015 09:43:52 GMT

Hey ,

Thanx but can you please give an example

Re: How to get selected value of field in Script ??

Anonymous — Fri, 27 Mar 2015 09:52:58 GMT

Please find the attachment

Re: How to get selected value of field in Script ??

nikhilgarg — Fri, 27 Mar 2015 09:56:28 GMT

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?

Re: How to get selected value of field in Script ??

Anonymous — Fri, 27 Mar 2015 10:31:55 GMT

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

];