Discussion board where members can get started with QlikView.
I have three tables contains,
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.
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.
can u post the 3 tables cols?
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.
charge as Amount,
'charge' as charge_type,
other fields for your filter needs
[extra charge] as Amount,
'extra charge' as charge_type,
[othercharge] as Amount,
'other charge' as charge_type,
This video will help immensely http://qlikshare.com/?s=Mapping.
Let me know.