topic Re: Restricting Filters on a exp. in QlikView

Restricting Filters on a exp.

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

Dear all,

This is my Exp. I want to restrict it for all filters which is present in the current sheet.

Count(Distinct {1<Date_Date={"$(=vToday)"}, Flag={'visits day & Type'}>} IH_EMR_PAT_ID )

stalwar1‌

mrkachhiaimp‌

mayilvahanan‌

mto‌

Regards,

Mohit Dahiya

Re: Restricting Filters on a exp.

its_anandrjs — Mon, 31 Oct 2016 07:49:30 GMT

In your expression add {1} to avoid all the filter selection.

Ex:-

Sum ({1} [Sales amount])

Your Expression

Count({1} Distinct {1<Date_Date={"$(=vToday)"}, Flag={'visits day & Type'}>} IH_EMR_PAT_ID )

Regards,

Anand

Re: Restricting Filters on a exp.

mohitd910 — Mon, 31 Oct 2016 08:24:54 GMT

Not working Bro

Re: Restricting Filters on a exp.

its_anandrjs — Mon, 31 Oct 2016 08:33:32 GMT

Check the attached example file.

In that no filter is affeted on the chart values.

Is this you required.

Regards

Anand

Re: Restricting Filters on a exp.

mohitd910 — Mon, 31 Oct 2016 08:53:16 GMT

i dont have server so i cant open this file can you send me the exp. i am using Qlik Sense

Re: Restricting Filters on a exp.

jagan — Mon, 31 Oct 2016 09:07:22 GMT

Hi Mohit,

Count({1<Date_Date={"$(=vToday)"}, Flag={'visits day & Type'}>} Distinct IH_EMR_PAT_ID )

This should work. Not sure why it is not working for you.

What is the value in the vToday? Is it changing based on the selections? In that case then you have to change that variable.

If you attach a sample file then it would be easier to provide solution.

Regards,

Jagan.

Re: Restricting Filters on a exp.

mohitd910 — Mon, 31 Oct 2016 09:10:06 GMT

Yes it is changes when i am selecting year.

vToday=Date(Max(Date_Date),'DD/MM/YYYY')

Re: Restricting Filters on a exp.

its_anandrjs — Mon, 31 Oct 2016 09:11:47 GMT

Expression is same also your expression is working

Count({1} Distinct {1<Date_Date={"$(=vToday)"}, Flag={'visits day & Type'}>} IH_EMR_PAT_ID )

Regards

Anand

Re: Restricting Filters on a exp.

mohitd910 — Mon, 31 Oct 2016 09:20:27 GMT

value for this exp is 1 by default for the Guest

but when i am selecting year 2015 see it will change to 5

Re: Restricting Filters on a exp.

jagan — Mon, 31 Oct 2016 09:32:50 GMT

Hi Mohit,

Try this, it won't change you variable.

vToday=Date(Max({1}Date_Date),'DD/MM/YYYY')

Regards,

jagan.

Re: Restricting Filters on a exp.

MK_QSL — Mon, 31 Oct 2016 09:33:36 GMT

vToday=Date(Max({1}Date_Date),'DD/MM/YYYY')

Your variable name is misleading ...

It should be vMaxDate.. !!!

Re: Restricting Filters on a exp.

jagan — Mon, 31 Oct 2016 09:38:01 GMT

Hi Mohit,

If your variable value changes then your expression value also changes. This is why you are getting different values when you are selecting even you give 1 in the expression.

Regards,

Jagan.

Re: Restricting Filters on a exp.

mohitd910 — Mon, 31 Oct 2016 09:38:47 GMT

No issue that can be any thing i have also vMaxDate it should work.

Re: Restricting Filters on a exp.

MK_QSL — Mon, 31 Oct 2016 09:39:55 GMT

vToday=Date(Max({1}Date_Date),'DD/MM/YYYY')

This variable is having {1} which is missing in your expression..

Re: Restricting Filters on a exp.

MK_QSL — Mon, 31 Oct 2016 09:55:46 GMT

I think jagan has given answer before me.. so you should have marked his answer correct (and my one helpful if you need to mark more than one answers)

Please make sure to mark correct/helpful answer wisely which will encourage other members to reply your questions.

Thanks

Re: Restricting Filters on a exp.

mohitd910 — Mon, 31 Oct 2016 10:01:59 GMT

Sry Jagan Bhai i didn't see

Re: Restricting Filters on a exp.

mohitd910 — Mon, 31 Oct 2016 10:04:36 GMT

Yes thanks sir Sry @jagan bhai. actually there were 3-4 replies courser directly go to last answer