Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

anuradhaa
Contributor

mapping tables

I have three tables contains,

charges

extra charges

other charges

these three tables has diffrent table structre and diffrent colums, so it difficult to union them in one table.

these charges has date say charge date, extra charge date, other charge date.

i have created calender tables uing all three tables.

i need to display total charge

charge+extra charge+other charge

so there how to set a calender (date filter) ?

i can use common date by renaming there,

but i have use other filtters and if i do so when some one clik a filter the values are not correct.

Please help

4 Replies
jeffmartins
Contributor II

Re: mapping tables

Hi anuradhaa,

You can rename all equivalent fields to the same field name on the three tables. Example: charge, extra charge and  other charge renamed to a new field called "charge", then concatenate the tables using concatenate() function.

Hope it helps you.

Regards

Not applicable

Re: mapping tables

Hi,

can u post the 3 tables cols?

Regards

Highlighted
alexpanjhc
Valued Contributor

Re: mapping tables

hi

I would concatenate the 3 tables.

change the name of the charge, extra charge and  other charge to Amount and add an extra charge type:

and you can sum the amount by using set analysis.

A:

load

charge as Amount,

dates ,

'charge' as charge_type,

other fields for your filter needs

from charge_table;

concatenate(A)

load

[extra charge] as Amount,

dates,

'extra charge' as charge_type,

other fields for your filter needs

from extra_charge_table;

concatenate(A)

load

[othercharge] as Amount,

dates,

'other charge' as charge_type,

other fields for your filter needs

from other_charge_table;

gabsus04
Valued Contributor II

Re: mapping tables

Hi,

This video will help immensely http://qlikshare.com/?s=Mapping.

Let me know.

Best Regards