topic Re: One Filter for Two Alternate States in QlikView

One Filter for Two Alternate States

Fri, 22 Aug 2014 06:22:05 GMT

Hi Community,

I have two compare two scenarios and for that I have two alternate state (as1,as2).

For this I have 5 (5X2) different filters, out of that three filter should be same for both states.

So is there any way I can use one filter for two alternate states.

Thanks in Advance

Prakash

Re: One Filter for Two Alternate States

vardhancse — Fri, 22 Aug 2014 06:24:03 GMT

Alternate state is only for comparative analysis.

Like base don the alternate state, the selections will pass.

Even though common filters, based on the alternate state the selections will pass.

Re: One Filter for Two Alternate States

sushil353 — Fri, 22 Aug 2014 06:26:31 GMT

Hi,

See if this can help you: Alternate States issue using same variable

HTH

Sushil

Re: One Filter for Two Alternate States

CELAMBARASAN — Fri, 22 Aug 2014 06:36:28 GMT

Yeah, you can do that. but it will something different

Keep those three filter in default state and in expression use something like this

Sum({$*[Alternate State1]} Sales)//$ represents default state

Re: One Filter for Two Alternate States

vardhancse — Fri, 22 Aug 2014 06:37:54 GMT

Hi,

If the objects have different alternate states.

How can the selections will pass.

CAn we pas variables directly.?

Re: One Filter for Two Alternate States

CELAMBARASAN — Fri, 22 Aug 2014 06:40:53 GMT

By using set analysis we can choose the state that needs to apply, regardless objects state.

Re: One Filter for Two Alternate States

Fri, 22 Aug 2014 06:44:07 GMT

Thanks all for your time any answers, I really appreciate your help a lot. 🙂

Re: One Filter for Two Alternate States

Tue, 02 Feb 2016 09:25:00 GMT

Hi celambarsan,

Thanks for your wonderful help.

The above expression is working fine for me also in my one case.But in anther case of second expression not able to implement please help me out.

Variables written in the script:

set vAffinity1 =sum({<affinity_id={1}>} affinity_param_count) / sum({<affinity_id={1}>}total_population_affinity);

set vAffinity2 =sum({<affinity_id={2}>} affinity_param_count) / sum({<affinity_id={2}>}total_population_affinity);

set vAffinity3 =sum({<affinity_id={3}>} affinity_param_count) / sum({<affinity_id={3}>}total_population_affinity);

set vAffinity4 =sum({<affinity_id={4}>} affinity_param_count) / sum({<affinity_id={4}>}total_population_affinity);

set vAffinity5 =sum({<affinity_id={5}>} affinity_param_count) / sum({<affinity_id={5}>}total_population_affinity);

Expression used in the text object.

X=Num((0.16 * $(vAffinity1)) + (0.27 * $(vAffinity2)) + (3.2 * $(vAffinity3)) + (4.65 * $(vAffinity4)) + (2.32 * $(vAffinity5)),'###.00')

We want to calculate the value of X based on the selection alternate state filters.

Please help me ASAP

Regards,

Venugopal G

Re: One Filter for Two Alternate States

Mon, 08 Feb 2016 10:48:20 GMT

Hi Celembarsan,

Above Expression is working for me..Thanks for your reply.

I Need one more help, One specific filter should not apply to chart even after making the selections in the filter.

Sum( {$*[StateA]} dollar_value_sold)

Please help me as soon as Possible.

Regards,

Venugopal G

Re: One Filter for Two Alternate States

CELAMBARASAN — Tue, 09 Feb 2016 18:38:26 GMT

if you want to ignore one specific filter

then you can use

Sum( {$*[StateA]<FieldNAme=>} dollar_value_sold)

Re: One Filter for Two Alternate States

Anonymous — Mon, 13 Mar 2017 22:33:09 GMT

Hi I tried the logic provided by you but I am not able to use Shop_Name filter as common for both states.Please see the sample file attached.

Re: One Filter for Two Alternate States

MuraliPrasath — Sat, 04 Apr 2020 05:59:10 GMT

Thanks bro, I had same query and got this fixed.

Re: One Filter for Two Alternate States

mariekaram — Tue, 25 May 2021 07:33:43 GMT

where i can write this expression

Sum({$*[Alternate State1]} Sales)//$ represents default state

in chart expression or filter expression?

Re: One Filter for Two Alternate States

DutchArjo — Tue, 14 May 2024 14:48:33 GMT

I have succesfully used a state in a chart to have the filter applied although the chart has a different state.

Now I have another chart on which I want to have a filter applied where that filter is in a different state.

Now the filter does not work unfortunately.

I do not understand what is going wrong.

The simple expression that works is:

Sum([ATNL_GRC statushouders PP+vbt])

After I change it to:

Sum({$<[ATNL_Luchtvaartmaatschappij]={[standaard-state]}>} [ATNL_GRC statushouders PP+vbt])

the chart has no values. ATNL_Luchtvaartmaatschappij is in the <standaard-state>.

using a state like this worked for me in a different dashboard where I used this expression:

=count({<[GAA_Controle]={'Ja'}, PRO_Centrumbrigade={[standaard_state]}>} GAA_Controle)/count(GAA_Controle)

I cannot find where my expression is going wrong or why it is not working as expected.