Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
kiranpatil123
Contributor III
Contributor III

Multiple dates using only 1 master calendar

Capture.PNG

Hi guys , please help on this task .

I have 2 tables say table 1 and 2 .Using ONLY 1 MASTER CALENDAR [ which includes both the dates (Date-1 and Date-2) ]

and also consider table- 1 as MASTER and Table-2 as TRANSACTION   .

I need the following scenarios

1) Based on S.no and Date-1  from [Table 1]  I need values from [Table 2]

2) Based on Date-1 from [Table1 ]  I need values from same table [Table 1]

3)  Based on Date-2 from [Table 2 ]  I need values from same table [Table 2]

. and I have attached the following files in order to solve the problem .

4 Replies
sasikanth
Master
Master

i might not correctly understand your requirement but try below exp

Try this,

1) =Sum({<[Date-1]=p([Date-2])>}Values)

2)=sum(value) (based on same table -1)

3) =sum(values) (based on same table -2)

ajsjoshua
Specialist
Specialist

Hi Kiran,

Try this

Canonical Date

Regards,

Joshua.

ajsjoshua
Specialist
Specialist

Hi,

PFA

kiranpatil123
Contributor III
Contributor III
Author

thanks you Joshua , but iam looking to use only 1 master calendar not multiple .