topic Re: Add only one Filter in chart. in QlikView

Add only one Filter in chart.

soha1902 — Thu, 19 Jun 2014 06:44:21 GMT

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..

Re: Add only one Filter in chart.

sushil353 — Thu, 19 Jun 2014 06:50:07 GMT

hi,

you can easily do this using set analysis.

In your chart in expression try as below

Sum({<filter1=,filter2=, filter3=>} data)

just replace filter1,filter2.. 3 with your actual filter/fields

HTH

Sushil

Re: Add only one Filter in chart.

soha1902 — Thu, 19 Jun 2014 06:59:32 GMT

Susheel thank you for your reply but I am using below if...else expreesion in my chart

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

Please suggest where I need to add filters now????

Re: Add only one Filter in chart.

tresB — Thu, 19 Jun 2014 07:00:38 GMT

And note that, you have to use the same set analysis in all the aggregation functions you have used(Sum, Max) in all your expressions.

Re: Re: Add only one Filter in chart.

ashfaq_haseeb — Thu, 19 Jun 2014 07:05:10 GMT

Had you look at the attached application

you can try below

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

Regards

ASHFAQ

Re: Add only one Filter in chart.

soha1902 — Thu, 19 Jun 2014 07:10:43 GMT

My original expression is :

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

Please suggest Set analysis as per this expression.

Please help......

Re: Re: Add only one Filter in chart.

its_anandrjs — Thu, 19 Jun 2014 07:13:30 GMT

Filters are applied in the Aggregation functions like SUM, COUNT, MAX etc

Eg:=

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

Re: Add only one Filter in chart.

soha1902 — Thu, 19 Jun 2014 07:36:28 GMT

I used this expression but still if I select others filters my chart get modified...

please help...

Re: Add only one Filter in chart.

ashfaq_haseeb — Thu, 19 Jun 2014 07:38:21 GMT

I have Checked your application.

It is effecting due to date but not due to excluded filter.

Hope it helped.

Regards

ASHFAQ

Re: Re: Add only one Filter in chart.

tresB — Thu, 19 Jun 2014 07:42:02 GMT

Soh, try this:

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

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

And remember, if you are using max()/min() in variable declaration use similary {1} there as well.

Re: Add only one Filter in chart.

soha1902 — Thu, 19 Jun 2014 07:44:06 GMT

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...

Re: Add only one Filter in chart.

ashfaq_haseeb — Thu, 19 Jun 2014 07:45:35 GMT

Try what Tresesco suggested.

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

Regards

ASHFAQ

Re: Re: Add only one Filter in chart.

tresB — Thu, 19 Jun 2014 07:48:42 GMT

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.

Re: Re: Add only one Filter in chart.

its_anandrjs — Thu, 19 Jun 2014 07:49:35 GMT

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))

Re: Add only one Filter in chart.

ashfaq_haseeb — Thu, 19 Jun 2014 07:50:33 GMT

Thanks for the info.

Regards

ASHFAQ

Re: Add only one Filter in chart.

soha1902 — Thu, 19 Jun 2014 07:52:27 GMT

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

Please help...

Re: Re: Add only one Filter in chart.

tresB — Thu, 19 Jun 2014 07:54:39 GMT

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

Re: Add only one Filter in chart.

ashfaq_haseeb — Thu, 19 Jun 2014 07:56:59 GMT

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

Re: Re: Add only one Filter in chart.

its_anandrjs — Thu, 19 Jun 2014 08:04:49 GMT

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))