Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
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
Creator II
Creator II

create a flag in script like below

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

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

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