topic Using expression in trigger (Select in field) in QlikView

Using expression in trigger (Select in field)

aisolomatin — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I need help with the expression for trigger.

I would like to make Text object with trigger for filtering values.

I got a simple load script:

Load * Inline [

product,amount,quontity

product1,100,10

product2,80,4

product3,120,5

];

I've made pivot table with expression"Price"=sum(amount)/sum(quontity).

I need to filter values with Price>15 by clicking on Text Object.

sunny_talwar — Sun, 09 Oct 2016 04:39:48 GMT

May be using this as the search string:

='=Sum(amount)/sum(quontity)>15'

aisolomatin — Sun, 09 Oct 2016 08:49:33 GMT

Thank you so much, Sunny!