topic Re: Not affect by a single filter in QlikView

Not affect by a single filter

eddywong71 — Wed, 11 Jan 2023 10:48:03 GMT

Hi All,

I have create a set analysis to show the latest 30 day of record under below

sum([$<[Datee]={">=$(=max([Datee])-30)<=$(=max([.Datee]|)"),[Product]={'car'),[Month ]=>} [Total Amount])

I want the chart not affect by the Month. Because i create a filter let the user choose the month.The set analysis should affect by other filter except Month.

Can anyone help.

Re: Not affect by a single filter

Timario — Wed, 11 Jan 2023 14:11:00 GMT

Hi. I take your expression and make some changes. Try it
sum({< [Datee] ={">=$(=date(max([Datee])-30))<=$(=max(Datee) )"}, Product={'car'}, [Month] >} [Total Amount] )

Re: Not affect by a single filter

eddywong71 — Thu, 12 Jan 2023 10:15:42 GMT

Hi Timario, i try this expression. However, the last 30 day still change base on the month selection. I want the last 30 day is fix no matter what the month choosing and is the latest.

Re: Not affect by a single filter

Timario — Thu, 12 Jan 2023 13:43:38 GMT

sum({<Datee, [Month], [Datee] ={">=$(=date(max([Datee])-30))<=$(=max(Datee) )"}, Product={'car'} >} [Total Amount] )

Other words, try write in set analysis variables which shouldn't affect on measure