topic Re: How to apply filter to a chart expression in QlikView

How to apply filter to a chart expression

trishita — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to apply filter to a chart expression

nishanthi_8 — Mon, 09 Jul 2018 06:04:33 GMT

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

Re: How to apply filter to a chart expression

trishita — Tue, 10 Jul 2018 08:51:14 GMT

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

Re: How to apply filter to a chart expression

nishanthi_8 — Tue, 10 Jul 2018 12:22:04 GMT

May I know the actual expression you used for it ?

Re: How to apply filter to a chart expression

trishita — Tue, 10 Jul 2018 13:15:12 GMT

I havent used any because I dont know what to do

Re: How to apply filter to a chart expression

neelamsaroha157 — Tue, 10 Jul 2018 13:21:27 GMT

Can you a share a sample file?

Re: How to apply filter to a chart expression

neelamsaroha157 — Tue, 10 Jul 2018 13:24:23 GMT

Maybe you can try something like this -

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

Re: How to apply filter to a chart expression

jonathandienst — Tue, 10 Jul 2018 13:29:39 GMT

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

Re: How to apply filter to a chart expression

trishita — Tue, 10 Jul 2018 14:40:06 GMT

This is the file i need to edit

Re: How to apply filter to a chart expression

neelamsaroha157 — Tue, 10 Jul 2018 15:03:06 GMT

Check this out.