Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

chart dimenstion not working

Hi, i m having an issue with a dimension not applying filter when double clicking on it.

I have 2 tables,

Resources:

rm_id, firstname, lastname

Employee:

rm_id,employee

I m trying to build a chart like below with list of rm_id that does not have an employee# in the system.

In order to get the above working i had a calculated dimension like,

=if (isnull(employee),'Unassigned',Null())

with Suppress When Values is Null option is checked.

And the expressions is like,

count(rm_id)

My issue is when i double click on the Unassigned item(blue) in the chart it does not apply the filter.

I have a same concept for a different field in a different chart but the below calculated dimension works.

=IF(trim(zzlwsnattrIsDisabled)='YES' OR trim(zzlwsnattrIsDisabled)='NO',Null(),'Unassigned')

So i believe the below calculated dimension is not able to apply filter 

=if (isnull(employee),'Unassigned',Null())

What is wrong with it?

4 Replies
Siva_Sankar
Master II
Master II

can you share example application?

-Siva

d_prashanthredd
Creator III
Creator III

Is your employee table is having rm_id if empl0yee# exists like below..

Resources:

load * Inline [

rm_id, firstname, lastname

1, AF, AL

2, BF, BL

3, CF, CL

4, DF, DL

5, EF, EL

];

join

Employee:

load * Inline [

rm_id, employee

1, A

2, B

3, C

4,

5,

];

In above case it will work.

Its better to share the sample app or data.

effinty2112
Master
Master

Hi,

try something like

MappingEmployee:

Mapping

LOAD

rm_id,

employee

Resident Employee;


Left Join:

Load

rm_id,

ApplyMap('MappingEmployee',rm_id,'Unassigned') as AssignedEmployee

Resident Resources;

Now your unassigned rm_id will have a field value of 'Unassigned' in the field AssignedEmployee.


cheers


Andrew

d_prashanthredd
Creator III
Creator III

You can do as Andres Walker suggested or else just do resident load as mentioned below..

Resources:

load * Inline [

rm_id, firstname, lastname

1, AF, AL

2, BF, BL

3, CF, CL

4, DF, DL

5, EF, EL

];

join (Resources)

Employee:

load * Inline [

rm_id, employee

1, A

2, B

3, C

];

Data:

load rm_id, firstname, lastname, if(IsNull(employee), '-', employee) Resident Resources;

drop Table Resources;

Now, you can achieve that what you are looking for..

Thanks,