Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
aisolomatin
Contributor III
Contributor III

Using expression in trigger (Select in field)

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.

1 Solution

Accepted Solutions
sunny_talwar

May be using this as the search string:

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


Capture.PNG

View solution in original post

2 Replies
sunny_talwar

May be using this as the search string:

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


Capture.PNG

aisolomatin
Contributor III
Contributor III
Author

Thank you so much, Sunny!