Add only one Filter in chart.

[soha1902]

Hi All,

I am having one line chart and some other chart objects,

I have four filters. Now my requirement is, my Line chart get affected only Date filter and other filter won't make any changes in my chart. I can not use alternate state because Date filter associated with other chart object.

So please let me how to Set Analysis in this case.

Please help..

[soha1902]

Hi Ashfaq,

I am using above expression as I mentioned my earlier message please suggest me how to add filter condition in that expression. I tried Aanand expression but it was not working..

please help...

[ashfaq_haseeb]

Try what Tresesco suggested.

But by that you wouldn't be able to filter by date.

Regards

ASHFAQ

[tresB]

Dear Ashfaq,

That would filter(or, let me say that respond to selection) by date because of the IF , and to be more specific this would only work if a Date is selected.

[its_anandrjs]

Then you can try with

if(date <= Date(Now()), Sum({1 <date={'>=$(vMinDate)<=$(=max(date))'},City=,Region= >}sales),
Sum({1 <date={'>=$(vMinDate)<=$(=max(date))'} ,City=,Region= >}sales))

[ashfaq_haseeb]

Thanks for the info.

Regards

ASHFAQ

[soha1902]

Still chart is get modified by others filters ....

Please help...

[tresB]

Why don't you share your sample app that has all variables and actual expression?

[ashfaq_haseeb]

Hi Soha,

I believe you have more then one expression

try to replicate below logic for all

=if(date <= Date(Now()), Sum({<date={'>=$(vMinDate)<=$(=max({1}date))'},City=,Region= >}sales),

Sum({<date={'>=$(vMinDate)<=$(=max({1}date))'} ,City=,Region= >}sales))

Or you can even try with below

=if(date <= Date(Now()), Sum({1 <date={'>=$(vMinDate)<=$(=max(date))'},City=,Region= >}sales),

Sum({1 <date={'>=$(vMinDate)<=$(=max(date))'} ,City=,Region= >}sales))

Regards

ASHFAQ

[its_anandrjs]

By using {1} in max expression in all expression is working from my side check once in your end

Expression1:- Sum( {<City=,Region=,Date={'>=$(vMinDate)<=$(=max({1}Date))'}>}Sales)

Expression2:-

if(Sum({<Date={'>=$(vMinDate)<=$(=max({1}Date))'},City=,Region=>}Sales)>=

above(Sum({<Date={'>=$(vMinDate)<=$(=max({1}Date))'},City=,Region=>}Sales))or  len(above(Sum({<Date={'>=$(vMinDate)<=$(=max({1}Date))'},City=,Region=>}Sales)))=0,

Sum({<Date={'>=$(vMinDate)<=$(=max({1}Date))'},City=,Region=>}Sales))

Expression3:-

if(Sum({<Date={'>=$(vMinDate)<=$(=max({1}Date))'},City=,Region=>}Sales)

<above(Sum({<Date={'>=$(vMinDate)<=$(=max({1}Date))'},City=,Region=>}Sales)),

Sum({<Date={'>=$(vMinDate)<=$(=max({1}Date))'},City=,Region=>}Sales))