topic Re: chart dimenstion not working in QlikView

chart dimenstion not working

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: chart dimenstion not working

Siva_Sankar — Mon, 31 Jul 2017 08:22:53 GMT

can you share example application?

-Siva

Re: chart dimenstion not working

d_prashanthredd — Mon, 31 Jul 2017 09:20:59 GMT

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

];

In above case it will work.

Its better to share the sample app or data.

Re: chart dimenstion not working

effinty2112 — Mon, 31 Jul 2017 09:30:29 GMT

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

Re: chart dimenstion not working

d_prashanthredd — Mon, 31 Jul 2017 09:49:34 GMT

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,