Make selection according to result in straight table

[#1]

Hello,

Do you know how to create following functionality:  We need make selection according to result of set analysis formula. We have initial data consist values mis, Operace, QlikView in field “aktivita”. In straight table we use set analysis formula “=if(sum(hodin) > 4, 1,0)“ The straight table then consist two values in field “aktivita” Can we use some QV functionality to make selection of this two values?

It is similar functionality to “searchable” function in straight table

Thank you for the advice

[Gysbert_Wassenaar]

See attached qvw. You will need something to trigger a Select in Field action. In the example this is done by clicking on the text box.

[#3]

Thank you for reply, it was very helpful.

There is only one problem, if dimension value consist space then it doesn't work. Do you know how to fix it?

See attached qv.

[Gysbert_Wassenaar · Accepted solution]

Sure, add double quotes around them:

='(' & concat(if(aggr(sum(hodin),aktivita)>4, chr(34) & aktivita & chr(34)),'|') & ')'