Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
trishita
Creator III
Creator III

How to apply filter to a chart expression

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

9 Replies
nishanthi_8
Creator
Creator

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
Creator III
Creator III
Author

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
Creator
Creator

May I know the actual expression  you used for it ?

trishita
Creator III
Creator III
Author

I havent used any because I dont know what to do

neelamsaroha157
Specialist II
Specialist II

Can you a share a sample file?

neelamsaroha157
Specialist II
Specialist II

Maybe you can try something like this -

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

jonathandienst
Partner - Champion III
Partner - Champion III

>>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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
trishita
Creator III
Creator III
Author

This is the file i need to edit

neelamsaroha157
Specialist II
Specialist II

Check this out.