Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Bhavani1
Contributor
Contributor

Removing rows based on measure in straight table.

Entire row should remove based on sum of converted amount <10000.

We have other fileds as well but i have taken few fileds.

sum(DISTINCT{<Filed1={'Yes'}, Filed2={'$(v_MaxTimestamp)'}>}Amount_Converted) this i have to restrict in straight table.Not in the script level.

1 Reply
brunobertels
Master
Master

Hi 

As mesure in your straight table 

if(

sum(DISTINCT{<Filed1={'Yes'}, Filed2={'$(v_MaxTimestamp)'}>}Amount_Converted)

>=10000,

sum(DISTINCT{<Filed1={'Yes'}, Filed2={'$(v_MaxTimestamp)'}>}Amount_Converted))

unchek "display others" in the option menu of the straight table.