Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
trishita
Contributor 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
Contributor

Re: How to apply filter to a chart expression

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
Contributor III

Re: How to apply filter to a chart expression

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
Contributor

Re: How to apply filter to a chart expression

May I know the actual expression  you used for it ?

trishita
Contributor III

Re: How to apply filter to a chart expression

I havent used any because I dont know what to do

neelamsaroha157
Valued Contributor II

Re: How to apply filter to a chart expression

Can you a share a sample file?

neelamsaroha157
Valued Contributor II

Re: How to apply filter to a chart expression

Maybe you can try something like this -

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

MVP
MVP

Re: How to apply filter to a chart expression

>>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
Contributor III

Re: How to apply filter to a chart expression

This is the file i need to edit

neelamsaroha157
Valued Contributor II

Re: How to apply filter to a chart expression

Check this out.