topic Re: mapping tables in QlikView

mapping tables

anuradhaa — Mon, 22 Oct 2012 16:02:14 GMT

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

Re: mapping tables

jeffmartins — Mon, 22 Oct 2012 16:31:40 GMT

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

Re: mapping tables

Mon, 22 Oct 2012 17:16:32 GMT

Hi,

can u post the 3 tables cols?

Regards

Re: mapping tables

alexpanjhc — Mon, 22 Oct 2012 19:20:43 GMT

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.

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;

Re: mapping tables

Gabriel — Mon, 22 Oct 2012 20:05:24 GMT

Hi,

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

Let me know.

Best Regards