Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
trishita
Creator III
Creator III

How to filter data in an existing table

I need to show records for data where the difference log is more than 10.How can I use filter in this respect.

Please refer to the attached image for the set of records

2 Replies
rajeshqvd
Creator II
Creator II

create a flag in script like below

if((Difference log vs)>10,'>10','<10') as MOrethan10

balabhaskarqlik

If your "Difference log vs Survey" calculation condition is like: ColumnA - ColumnB.

modify it like: If((ColumnA-ColumnB) > 10, (ColumnA-ColumnB)).