Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
chauhans85
Esteemed Contributor

Re: Common calendar

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

8 Replies
chauhans85
Esteemed Contributor

Re: Common calendar

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

Not applicable

Re: Common calendar

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

chauhans85
Esteemed Contributor

Re: Common calendar

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

Not applicable

Re: Common calendar

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

chauhans85
Esteemed Contributor

Re: Common calendar

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

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

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

hope this helps

Not applicable

Re: Common calendar

Thankyou SK C,

Not applicable

Re: Common calendar

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.

chauhans85
Esteemed Contributor

Re: Common calendar

we can concatenate without field mapping also

hope this helps

Community Browser