Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Common calendar

Hi,

I have 3 transaction tables:

1)Daily sales

2)monthly sales

3)target sales

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 ..

regards,

baru

1 Solution

Accepted Solutions
SunilChauhan
Champion
Champion

TempCal:

Load

Date as CommonDate

from Daily sales

concatenate

load

Date as CommonDate

from Monthly sales

Concatenate

Load

Datefield as CommonDate

from target sales;

MasterCal:

Load

Commondate,

Year(Commondate) as CommonYear

Month(Commondate) as CommonMonth,

..

,

.....

resident TempCal;

drop table  TempCal;

you can calculate any field from Commondate in Mater Cal

hope this helps

Sunil Chauhan

View solution in original post

8 Replies
SunilChauhan
Champion
Champion

TempCal:

Load

Date as CommonDate

from Daily sales

concatenate

load

Date as CommonDate

from Monthly sales

Concatenate

Load

Datefield as CommonDate

from target sales;

MasterCal:

Load

Commondate,

Year(Commondate) as CommonYear

Month(Commondate) as CommonMonth,

..

,

.....

resident TempCal;

drop table  TempCal;

you can calculate any field from Commondate in Mater Cal

hope this helps

Sunil Chauhan
Not applicable
Author

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,

regards,

baru

SunilChauhan
Champion
Champion

you try using flag for all three tables

like

Monthly as flag

daily as Flag

target as flag in all three table

and calculate your sales based ion flag

Hope this helps

Sunil Chauhan
Not applicable
Author

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,

regards,

baru

SunilChauhan
Champion
Champion

sum({<Flag={'Monthly '}>}SalesAmountFiled)

sum({<Flag={'Daily'}>}SalesAmountFiled)

sum({<Flag={'target'}>}SalesAmountFiled)

hope this helps

Sunil Chauhan
Not applicable
Author

Thankyou SK C,

Not applicable
Author

Hi, SK C

I have seen the solution. You concatenated three tables.

Monthly

Daily

Target.

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.

SunilChauhan
Champion
Champion

we can concatenate without field mapping also

hope this helps

Sunil Chauhan