How to apply filter to a chart expression

[trishita]

How can I apply filter (hardcoded or static filter) to fetch some records in a table chart.As we all know that there are no specific filter feature in qlikview report like other bi tools,help would be appreciated.

I would like to show record of all data for a specific SURVEY ID where the column Difference  Log  vs Survey is greater than 10 and smaller than -10.

Secondly, I also tried to write a conditional statement like:

IF SOUNDING CORRECTION DATE Y>= Survey date and < Survey date + 7,and ​​Difference  Log  vs Survey is greater than 10 and smaller than -10,then return all the records for a specific survey id or IMO NO.I had tried this with interval match already in the script,but also was looking for some suggestions for some report level expression statements as well.

PFA sample of the record

[nishanthi_8]

Hi Trishita . Your requirement is to sort the "Difference Log vs Survey" in an order irrespective of Survey ID isnt't it? Correct me if I am wrong

[trishita]

No I just want to show records for those SURVEY IDS where the Difference  Log  vs Survey is greater than 10 and smaller than -10.

Sorting is easy, but I want to pick the values in the given range

[nishanthi_8]

May I know the actual expression  you used for it ?

[trishita]

I havent used any because I dont know what to do

[neelamsaroha157]

Can you a share a sample file?

[neelamsaroha157]

Maybe you can try something like this -

=Count({$<[Diff Log vs Survey]={">=10<=-10"}>}SurveyID)

[jonathandienst]

>>As we all know that there are no specific filter feature in qlikview report like other bi tools,

We do?

I would add the following lines  to the load

...   

If([SOUNDING CORRECTION DATE] >= [SURVEY DATE] and [SOUNDING CORRECTION DATE] < [SURVEY DATE] + 7, 1, 0) as Flag1,

If(Fabs([Difference Log vs Survey]) > 10, 1, 0) as Flag2,

...

And then add the following set clause to your table expressions:

{<Flag1 = {1}, Flag2 = {1}>}

You may need to adjust for the correct field names as your post does not tell us very much, nor does the picture.

[trishita]

This is the file i need to edit

[neelamsaroha157]

Check this out.