Qlik Sense Filter Issue

[piyush_s11]

Hi,

I am using a filter where for that filter I am using below formula

=if(loaddate1 >= Date(AddMonths(Today(),-12),'DD/MMM/YYYY'),Extract_Date)

Now issue here is whenever I select this filter by default loaddate1 filter is also getting applied as shown in below image.

I do not want loaddate1 filter to be applied only Extract_Date filter should be applied.

Please Note: Both the field loaddate1 & Extract_Date are having different values.

@avinashelite  @kushalthakral @sunny_talwar @Anil_Babu_Samineni @MayilVahanan @tresesco @prabir_c @kaushiknsolanki @anbu1984 

Thanks in Advance.

[MayilVahanan]

Hi

Can you bring one more field with the same logic in script instead of doing in the front end calculation.

Hope it will be fast and solve ur issue.

[piyush_s11]

Hi @MayilVahanan 

Thank you for your quick reply.

It will be difficult to add this logic in back end. Is it possible we can fix in front end.

Thanks in Advance.

[Anil_Babu_Samineni]

@piyush_s11 Can you try using Exclude, example like?

=if(loaddate1 >= Date(AddMonths(Today(),-12),'DD/MMM/YYYY'), Only({<loaddate1=E(loaddate1)>} Extract_Date))