Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

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.

View solution in original post

6 Replies
Highlighted
Partner
Partner

your explanation is not clear.

what's your needs and your expected result ?

Highlighted

May be create like?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Creator
Creator

Hi Girish,

can you please provide sample data.

Highlighted
Contributor III
Contributor III

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

Highlighted
Partner
Partner

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.

View solution in original post

Highlighted
Creator
Creator

Hi Girish,

check @Andrea method is working