topic Re: Problem with mapping load in QlikView

Problem with mapping load

Fri, 30 May 2014 15:14:34 GMT

I created a sample dashboard showing the problem I'm having.

I want to be able to map the Locality and CCG name to the DA table, but I'm not having much luck. I have a dashboard where a number of metrics is calculated over these dimensions and the problem with DA table is that when I select a SiteType I don't know what Locality and CCG the associated PracticeDI belongs to.

Any ideas?

Re: Problem with mapping load

Fri, 30 May 2014 15:20:50 GMT

DA:

LOAD * INLINE [

PracticeDI, SiteType

Bewick Crescent Surgery, Practice

Bewick Road Surgery, Practice

Birtley Medical Group, Practice

Blacketts Medical Practice, Practice

CareFirst, CCG

Churchill Medical Centre, Practice

Holmside Medical Group, Practice

Sedbergh Health Centre, Practice

];

GA:

LOAD * INLINE [

SiteType, Practice, Locality, CCG

CCG, CareFirst, None, CareFirst

Practice, Bewick Crescent Surgery, Sedgefield Locality, DDES CCG

Practice, Bewick Road Surgery, None, CBC

Practice, Birtley Medical Group, None, CBC

Practice, Blacketts Medical Practice, None, Darlington CCG

Practice, Churchill Medical Centre, None, Kingston CCG Central Office

Practice, Holmside Medical Group, None, Newcastle West Clinical Commissioning Group

Practice, Sedbergh Health Centre, None, Cumbria

];

Does this work for you?

Re: Problem with mapping load

Fri, 30 May 2014 15:24:30 GMT

I wouldn't be able to use that in my script. I'm after a mapping load...

Re: Problem with mapping load

its_anandrjs — Fri, 30 May 2014 15:32:16 GMT

Try with the mapping load

DAMap:

Mapping LOAD * INLINE [

Practice, SiteType

Bewick Crescent Surgery, Practice

Bewick Road Surgery, Practice

Birtley Medical Group, Practice

Blacketts Medical Practice, Practice

CareFirst, Ccg

Churchill Medical Centre, Practice

Holmside Medical Group, Practice

Sedbergh Health Centre, Practice

];

GA:

LOAD *,ApplyMap('DAMap',Practice) as PracticeDesc;

LOAD * Inline

[

SiteTypeID, Practice, Locality, CCG

CCG, CareFirst, None, CareFirst

Practice, Bewick Crescent Surgery, Sedgefield Locality, DDES CCG

Practice, Bewick Road Surgery, None, CBC

Practice, Birtley Medical Group, None, CBC

Practice, Blacketts Medical Practice, None, Darlington CCG

Practice, Churchill Medical Centre, None, Kingston CCG Central Office

Practice, Holmside Medical Group, None, Newcastle West Clinical Commissioning Group

Practice, Sedbergh Health Centre, None, Cumbria

];

Re: Problem with mapping load

Colin-Albert — Fri, 30 May 2014 15:38:11 GMT

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='£#,##0.00;-£#,##0.00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

DA_Map:

Mapping

LOAD * INLINE [
    PracticeDI, SiteTypeDI
    Bewick Crescent Surgery, Practice
    Bewick Road Surgery, Practice
    Birtley Medical Group, Practice
    Blacketts Medical Practice, Practice
    CareFirst, Ccg
    Churchill Medical Centre, Practice
    Holmside Medical Group, Practice
    Sedbergh Health Centre, Practice
];

Locality_Map:

Mapping

LOAD * INLINE [
Practice, Locality
Bewick Crescent Surgery, Sedgefield Locality
];

CCG_Map:

Mapping

LOAD * INLINE [
    Practice, CCG
     CareFirst, CareFirst
     Bewick Crescent Surgery, DDES CCG
     Bewick Road Surgery, CBC
     Birtley Medical Group, CBC
     Blacketts Medical Practice, Darlington CCG
     Churchill Medical Centre, Kingston CCG Central Office
     Holmside Medical Group, Newcastle West Clinical Commissioning Group
     Sedbergh Health Centre, Cumbria
];

GA:

LOAD Practice,

Applymap('DA_Map', Practice) as SiteType,

Applymap('Locality_Map', Practice, 'None' ) as Lacality,

Applymap('CCG_Map', Practice ) as CCG

INLINE [
    Practice
     CareFirst
     Bewick Crescent Surgery
     Bewick Road Surgery
     Birtley Medical Group
     Blacketts Medical Practice
     Churchill Medical Centre
     Holmside Medical Group
     Sedbergh Health Centre
];

Re: Problem with mapping load

maxgro — Fri, 30 May 2014 15:41:10 GMT

DA:

LOAD * INLINE [

PracticeDI, SiteTypeDI

Bewick Crescent Surgery, Practice

Bewick Road Surgery, Practice

Birtley Medical Group, Practice

Blacketts Medical Practice, Practice

CareFirst, CCG

Churchill Medical Centre, Practice

Holmside Medical Group, Practice

Sedbergh Health Centre, Practice

];

left join (DA) load

SiteType as SiteTypeDI,

Practice as PracticeDI,

Locality,

CCG;

//GA:

LOAD * INLINE [

SiteType, Practice, Locality, CCG

CCG, CareFirst, None, CareFirst

Practice, Bewick Crescent Surgery, Sedgefield Locality, DDES CCG

Practice, Bewick Road Surgery, None, CBC

Practice, Birtley Medical Group, None, CBC

Practice, Blacketts Medical Practice, None, Darlington CCG

Practice, Churchill Medical Centre, None, Kingston CCG Central Office

Practice, Holmside Medical Group, None, Newcastle West Clinical Commissioning Group

Practice, Sedbergh Health Centre, None, Cumbria

];

Re: Problem with mapping load

maxgro — Fri, 30 May 2014 15:46:23 GMT

or this?

GA:

LOAD * INLINE [

SiteType, Practice, Locality, CCG

CCG, CareFirst, None, CareFirst

Practice, Bewick Crescent Surgery, Sedgefield Locality, DDES CCG

Practice, Bewick Road Surgery, None, CBC

Practice, Birtley Medical Group, None, CBC

Practice, Blacketts Medical Practice, None, Darlington CCG

Practice, Churchill Medical Centre, None, Kingston CCG Central Office

Practice, Holmside Medical Group, None, Newcastle West Clinical Commissioning Group

Practice, Sedbergh Health Centre, None, Cumbria

];

MAP_GA_1:

mapping load

SiteType & '-' & Practice,

CCG

Resident GA;

MAP_GA_2:

mapping load

SiteType & '-' & Practice,

Locality

Resident GA;

DA:

load

PracticeDI,

SiteTypeDI,

ApplyMap('MAP_GA_1', SiteTypeDI & '-' & PracticeDI) as NewField1,

ApplyMap('MAP_GA_2', SiteTypeDI & '-' & PracticeDI) as NewField2;

LOAD * INLINE [

PracticeDI, SiteTypeDI

Bewick Crescent Surgery, Practice

Bewick Road Surgery, Practice

Birtley Medical Group, Practice

Blacketts Medical Practice, Practice

CareFirst, CCG

Churchill Medical Centre, Practice

Holmside Medical Group, Practice

Sedbergh Health Centre, Practice

];

drop table GA;

Re: Problem with mapping load

Fri, 30 May 2014 20:23:20 GMT

Witaj,

czy problem rozwiązany??

pozdrawiam

Re: Problem with mapping load

Sun, 01 Jun 2014 11:50:30 GMT

Hi Katarzyna

Why dont you want to link the tables using practise?

* INLINE [

    Practice, SiteTypeDI

    Bewick Crescent Surgery, Practice

    Bewick Road Surgery, Practice

    Birtley Medical Group, Practice

    Blacketts Medical Practice, Practice

    CareFirst, Ccg

    Churchill Medical Centre, Practice

    Holmside Medical Group, Practice

    Sedbergh Health Centre, Practice

];

GA:

LOAD * INLINE [

    SiteType, Practice, Locality, CCG

    CCG, CareFirst, None, CareFirst

    Practice, Bewick Crescent Surgery, Sedgefield Locality, DDES CCG

    Practice, Bewick Road Surgery, None, CBC

    Practice, Birtley Medical Group, None, CBC

    Practice, Blacketts Medical Practice, None, Darlington CCG

    Practice, Churchill Medical Centre, None, Kingston CCG Central Office

    Practice, Holmside Medical Group, None, Newcastle West Clinical Commissioning Group

    Practice, Sedbergh Health Centre, None, Cumbria

];

Thanks and regards

Padma

Re: Problem with mapping load

Mon, 02 Jun 2014 08:10:30 GMT

Tak Dariusz, bledem okazal sie niewlasciwy mapping load, bardzo czesto rozwiazanie samo wpada do glowy po opublikowaniu problemu wlasnie tutaj

pozdrawiam Kasia

Re: Problem with mapping load

Mon, 02 Jun 2014 08:11:12 GMT

Thank you for your help everyone, I managed to fix the problem - my mapping load was incorrect.

Re: Problem with mapping load

Mon, 02 Jun 2014 08:22:39 GMT