Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

girishrainbow
New Contributor II

Filters

Hello Friends

I have 5 units where 4 units are different like A,B,C,D But 5 unit in Z=(A+B+C+D) you can say consolidated

which i have kept in filter

so i want when i click on Z i want to select rest all A,B,C,D but not Z in filter ..

Thanks In Advance

Tags (2)
1 Solution

Accepted Solutions
agigliotti
Honored Contributor II

Re: Filters

you can do something as below in script:

load

BU,

Actual,

Budget,

BU as BU_new

from your_table where BU <> 'E';

concatenate
load distinct

    BU,

    'E' as BU_new

from your_table where BU <> 'E';


and use the new field BU_new in filter.

6 Replies
agigliotti
Honored Contributor II

Re: Filters

your explanation is not clear.

what's your needs and your expected result ?

Re: Filters

May be create like?

Only({<FieldName = E(FieldName)>} units)

anatbabv
Contributor

Re: Filters

Hi Girish,

can you please provide sample data.

girishrainbow
New Contributor II

Re: Filters

BU
Actual
Budget
A1020
B1020
C2010
D3010
E(A+B+C+D)7060

i have many records i have filter where BU is there

but when i select E i want to select A,B,C,D BECAUSE the data is incorrect or u can say they have many more BU but they have not shared but they want E also but when in selection they want E to select but to display data of A,B,C,D in table or bar chart

hope i am clear now

agigliotti
Honored Contributor II

Re: Filters

you can do something as below in script:

load

BU,

Actual,

Budget,

BU as BU_new

from your_table where BU <> 'E';

concatenate
load distinct

    BU,

    'E' as BU_new

from your_table where BU <> 'E';


and use the new field BU_new in filter.

anatbabv
Contributor

Re: Filters

Hi Girish,

check @Andrea method is working