Hello!
Could you please help me to resolve this problem if it's possible or to to find a way around...
I have 10 lists of specialties(Let's take a look only at Specilaty1, Specialty2). for Company1, Company2,etc...
I'm trying to load data
table:
Load Distinct
Specialty1 as Specialty
,[p11] as p1
,[p12] as p2
,[p13] as p3
,[p14] as p4
,'Company1' as Company
from
[Lib://.../Company1.qvd] (qvd)
Concatenate
Load Distinct
Specialty2 as Specialty
,[p21] as p1
,[p22] as p2
,[p23] as p3
,[p24] as p4
,'Company2' as Company
from
[Lib:/.../Company2.qvd] (qvd)
As a result, I want to have 2 filter(10 in real life)
one with specialties for company1,another with specialties for company2
and to show in final table the following columns depending on their specialties(filters):
company,p1,p2,p3,p4.
My problem is that qlik sense doesn't allow me to chose independently specialties from my two filters. If I chose specialty from one filter, it greys out other specialties from the second filter. I need them to be independent.
I used this formulas for my filters
=Aggr(Only({<Company = {'123'}>} Specialty), Specialty) and =if(Company='123',Specialty)
Thanks a lot in advance!
