topic Re: SELECT WITH ACTION in QlikView

SELECT WITH ACTION

adiarnon — Mon, 06 Oct 2014 14:37:07 GMT

HI,

i have a button that i want that a click will make a selection in project field-

so i add action

select in field

the field name -"Project"

in the search string-

='('&concat(if(Aggr((Sum({<[BUDGET VERSION]={1)}>}ActualCurrentBook_$(vFinanceFormula)))/

(Sum({<[BUDGET VERSION]={1}>}BudgetCurrentBook_$(vFinanceFormula))),Project)>=1,Project),'|')&')'

and when im clicking its diong nothing!

i put the expression in a textbox-

='('&concat(if(Aggr((Sum({<[BUDGET VERSION]={1)}>}ActualCurrentBook_$(vFinanceFormula)))/
(Sum({<[BUDGET VERSION]={1}>}BudgetCurrentBook_$(vFinanceFormula))),Project)>=1,Project),'|')&')'

its gives me- (111|232|111)

what am i doing wrong?

adi

Re: SELECT WITH ACTION

adiarnon — Mon, 06 Oct 2014 14:52:47 GMT

Re: SELECT WITH ACTION

Anonymous — Mon, 06 Oct 2014 14:53:46 GMT

Looks right... Try to hardcode (111|232|111), and try to use ToggleSelect, although Select must work too.

Besides, use distinct concat avoid 111 twice

Re: SELECT WITH ACTION

adiarnon — Mon, 06 Oct 2014 15:06:29 GMT

hi,

tnx

i think i know what the problem bul i dont know what to do.

i will explain-

when im using the function -

GetFieldSelections(Project)

i get - 111, 222, 333 and not- (111|222|333)

i one of my other models i did get (111|222|333) and the selection worked in that model.

but i dont know why its not the same and where can i control it...

someone can help?

Re: SELECT WITH ACTION

JonnyPoole — Mon, 06 Oct 2014 15:12:05 GMT

You can define the delimitter as an argument for 'getfieldslections' and then add the '(' and ')'.

='(' &GetFieldSelections(Project , '|') & ')'

Re: SELECT WITH ACTION

adiarnon — Tue, 07 Oct 2014 04:38:49 GMT

tnx good to know...

but this is not my problem...

im tring to make a selection in a field with an action.

i cant find the expression that i shoud insert

because my expression is not working and i dont know why-

='('&concat(if(Aggr((Sum({<[BUDGET VERSION]={1)}>}ActualCurrentBook_$(vFinanceFormula)))/
(Sum({<[BUDGET VERSION]={1}>}BudgetCurrentBook_$(vFinanceFormula))),Project)>=1,Project),'|')&')'

someone?

Re: SELECT WITH ACTION

jagan — Tue, 07 Oct 2014 05:12:18 GMT

Hi Adi,

Try this expression

='('&concat(Aggr(if((Sum({<[BUDGET VERSION]={1}>}ActualCurrentBook_$(vFinanceFormula))/

Sum({<[BUDGET VERSION]={1}>}BudgetCurrentBook_$(vFinanceFormula)))>=1,Project), Project),'|')&')'

What is there in vFinanceFormula? Can you elaborate what you are try to do with a sample file?

Regards,

Jagan.

Re: SELECT WITH ACTION

adiarnon — Tue, 07 Oct 2014 14:31:32 GMT

tnx evryone!

it was a syntax mistake

Re: SELECT WITH ACTION

jagan — Wed, 08 Oct 2014 01:02:37 GMT

Hi Adi,

Close this thread.

Regards,

Jagan.