topic Filter in QlikView

Filter

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

Hi Expertise ,

Iam using the below expreesioon in a straight table ..and there are 4 expression like the below..

I have 3 filters ( Dept, Agency,Date)

=Sum({<PeriodType={'CurrentOpen'},DefectCountLoadDate={">=$(=Date(addmonths(Max(DefectCountLoadDate))))"} >} OpenCount)

Now i want to exclude the selection made for the filter "Agency " in the straight table and other filters should work normally .

And there are different tables which should reflect the changes normally

How can i acheive this Please Expertise help me

Thanks in Advance

Anil_Babu_Samineni — Wed, 11 Oct 2017 09:50:19 GMT

Like this?

=Sum({$<Agency=, PeriodType={'CurrentOpen'},DefectCountLoadDate={">=$(=Date(addmonths(Max(DefectCountLoadDate))))"} >} OpenCount)

smilingjohn — Wed, 11 Oct 2017 10:09:19 GMT

Hi Anil ,

In a caption iam using The date accordingly ,

How should i use the same here ?

Date(Max(DefectCountLoadDate), 'MMM-YYYY')

Anil_Babu_Samineni — Wed, 11 Oct 2017 10:10:53 GMT

You can do even with Max

Date(Max({$<Agency= >} DefectCountLoadDate), 'MMM-YYYY')

Kushal_Chawda — Wed, 11 Oct 2017 10:12:05 GMT

try this

Date(Max({<Agency>}DefectCountLoadDate), 'MMM-YYYY')

smilingjohn — Wed, 11 Oct 2017 10:19:13 GMT

Thanks a lot Anil Sir