Discussion Board for collaboration on QlikView Layout & Visualizations.
I have 3 transaction tables:
How can i create common calendar for this, what filed i have to use in my reports expressions.
My date field is only one that is "SalesUploadDate".Please find the attachment
can anyone know this ..
Go to Solution.
Date as CommonDate
from Daily sales
from Monthly sales
Datefield as CommonDate
from target sales;
Year(Commondate) as CommonYear
Month(Commondate) as CommonMonth,
drop table TempCal;
you can calculate any field from Commondate in Mater Cal
hope this helps
Hi SK C,
Thanks for reply,
i have a dought,in my reports i am calculating one column is for monthly sales it is from monthly sales table,
one column is for target for months it is from target table,one column for daily sales it is from daily sales table.
which field i have to consider for different columns,it will get duplicate records.
please help me,
you try using flag for all three tables
Monthly as flag
daily as Flag
target as flag in all three table
and calculate your sales based ion flag
Hope this helps
ThankYou SK C,
can i have one example for this and example for expression how to write in the chart level.
For understanding the concept,
Thankyou SK C,
Hi, SK C
I have seen the solution. You concatenated three tables.
Among these three tables Target table fields are not maching with daily and monthly table fields. So can you tell me how can we concatente if there are dissimilar
fileds b/w two fileds. Please suggest me.
Thanks in advance.
we can concatenate without field mapping also