mapping tables

[anuradhaa]

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

[jeffmartins]

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

[#3]

Hi,

can u post the 3 tables cols?

Regards

[alexpanjhc]

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;

[Gabriel]

Hi,

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

Let me know.

Best Regards