Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
adiarnon
Creator III
Creator III

SELECT WITH ACTION

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

1 Solution

Accepted Solutions
adiarnon
Creator III
Creator III
Author

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?

View solution in original post

8 Replies
adiarnon
Creator III
Creator III
Author

?

Anonymous
Not applicable

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

adiarnon
Creator III
Creator III
Author

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?

JonnyPoole
Employee
Employee

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


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

adiarnon
Creator III
Creator III
Author

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?

jagan
Luminary Alumni
Luminary Alumni

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.

adiarnon
Creator III
Creator III
Author


tnx evryone!

it was a syntax mistake

jagan
Luminary Alumni
Luminary Alumni

Hi Adi,

Close this thread.

Regards,

Jagan.