topic condition in mapping in QlikView

condition in mapping

Tue, 20 Sep 2011 08:49:54 GMT

Hi All,

I have a question

How can i do a condition on mapping

i.e

i have column called 'Year' in table nad i have column called 'Future' in another table

what i want is to make this mapping

LOAD * Inline

[

Activity,Future

A,004

B,006

C,005

D,000

];

for Year=2009

and to make this mapping

LOAD * Inline

[

Activity,Future

A,003

B,006

B,005

D,004

];

for Year=2010

how can i do that??

condition in mapping

swuehl — Tue, 20 Sep 2011 09:10:28 GMT

Hi Mona,

I think you could either use one mapping tabel, and combine e.g. Year and Activitiy as YearActivitiy to map, like

MapTableA:

Mapping LOAD * INLINE [

YearActivity, Future

2009A, 004

2010A, 003

2009B, 006

2010B, 006

...

];

and use applymap with a dynamical build YearActivity in the table you want to apply the mapping to,

use two mapping tables with distinct table name (MapTable2009, MapTable2010) and use a condition (if() / pick() ) to select the correct mapping table name for applymap.

I haven't tried nested applymaps as third idea (use a map to retrieve the mapping table name from given year), don't know if this works at all.

But first two ideas should work.

Regards,

Stefan

condition in mapping

Tue, 20 Sep 2011 09:15:08 GMT

Thanks Stefan,

But how can i combine Year with Activity

Year is a field name in the table How can i combine it with the column i will name??

condition in mapping

Tue, 20 Sep 2011 09:16:30 GMT

i want when i select the year i want

the correct mapping to be applied

condition in mapping

swuehl — Tue, 20 Sep 2011 09:32:20 GMT

So activity and future do only exist in your above two tables and you don't want a static mapping in the load?

What about a table like

LOAD * INLINE[

Year, Activity, Future

2009, A, 004

2010, A, 003

2009, B, 006

2010, B, 006

...

];

This should link your selected year to the appropriate Activity / Future combinations?

Well I think I misses your point, could you explain your data model and your business goal a bit more, please?

Regards,

Stefan

condition in mapping

Wed, 21 Sep 2011 11:24:49 GMT

Thanks Stefan

i didn't know if there was available to make 3 fields in mapping but now i did know