Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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

?

mov
Champion III
Champion III

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?

View solution in original post

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.