topic Re: Common calendar in QlikView

Common calendar

Sat, 27 Oct 2012 15:11:16 GMT

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

Re: Common calendar

SunilChauhan — Sat, 27 Oct 2012 15:18:10 GMT

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

Re: Common calendar

Sat, 27 Oct 2012 15:26:43 GMT

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

Re: Common calendar

SunilChauhan — Sat, 27 Oct 2012 15:38:22 GMT

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

Re: Common calendar

Sat, 27 Oct 2012 15:44:59 GMT

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

Re: Common calendar

SunilChauhan — Sat, 27 Oct 2012 16:12:40 GMT

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

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

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

hope this helps

Re: Common calendar

Sat, 27 Oct 2012 16:53:17 GMT

Thankyou SK C,

Re: Common calendar

Thu, 08 Nov 2012 10:54:10 GMT

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.

Re: Common calendar

SunilChauhan — Thu, 08 Nov 2012 10:59:40 GMT

we can concatenate without field mapping also

hope this helps