topic Re: How to make a data selection trigger? in QlikView

How to make a data selection trigger?

tomdabek — Tue, 10 Oct 2017 12:31:23 GMT

Hello,

We have an application where customers can make 2 types of purchases - lets call them balls and sticks, the field is called 'SaleType'.

I would like to activate a trigger so when a user opens a particular sheet, only customers who have purchased both balls and sticks are selected.

Any guidance is appreciated.

Thank you.

Re: How to make a data selection trigger?

marcus_sommer — Tue, 10 Oct 2017 12:50:52 GMT

Maybe with something like this as search-expression within a the trigger:

= '("' & concat({< SaleType = {'balls'}> * < SaleType = {'sticks'}>} distinct customer, '"|"') & '")'

- Marcus

Re: How to make a data selection trigger?

jonathandienst — Tue, 10 Oct 2017 12:53:13 GMT

Are you sure that a trigger is the best way to do this? I would use set expressions that filter for both balls and sticks, rather than a triggered selection.

In a chart/table, something like

Sum({<Customer = P({<SaleType = {'balls'}>*<SaleType = {'sticks'}>} Customer)>} Sales)

(although its easier to develop and test something like this if you provide a sample qvw file)

Re: How to make a data selection trigger?

Kushal_Chawda — Tue, 10 Oct 2017 12:53:18 GMT

Sheet on which you want to select the customers, go to sheet properties-> Triggers -> Add Action on Activation of sheet -> Add->Selections->Select in Field->

Field : Customer

Search Staring : ='(' &concat(distinct {<SaleType={'Balls'}>*<SaleType={'sticks'}>} chr(34) & Customer & chr(34)) &')'

Re: How to make a data selection trigger?

tomdabek — Tue, 10 Oct 2017 15:29:07 GMT

So I haven't had much luck with this. I have tried a few things using the suggestions above.

Right now as a trigger I have:

='(' &concat(distinct {<ROCKApplication={'AGG'}>*<ROCKApplication={'Fill'}>} chr(34) & %customer & chr(34)) &')'

on the field %customer

However, when the sheet is activated, I cannot see anything in the 'Current Selections Box'.

Should this appear in the current selection box?

I have tried another trigger, on a different field, and in the Search String i just have (AGG|Fill) and while it does not accomplish what i am trying to do, at least in the current selections box i can see that these fields have been selected.

Re: How to make a data selection trigger?

Kushal_Chawda — Tue, 10 Oct 2017 15:49:30 GMT

Try this

='(' &concat(distinct {<ROCKApplication={'AGG'}>*<ROCKApplication={'Fill'}>} chr(34) & %customer & chr(34), ', ') &')'

Re: How to make a data selection trigger?

marcus_sommer — Tue, 10 Oct 2017 15:52:45 GMT

The delimiter for the dimension-values needs to be the pipe-sign '|' and not the comma.

- Marcus

Re: How to make a data selection trigger?

Kushal_Chawda — Tue, 10 Oct 2017 16:06:58 GMT

I think with single quotes and comma its works. Not sure

='(' &concat(distinct {<ROCKApplication={'AGG'}>*<ROCKApplication={'Fill'}>} chr(39) & %customer & chr(39), ', ') &')'