topic Multiple dates using only 1 master calendar in QlikView

Multiple dates using only 1 master calendar

kiranpatil123 — Wed, 25 Nov 2020 16:16:04 GMT

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 .

sasikanth — Fri, 24 Feb 2017 06:13:59 GMT

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 — Fri, 24 Feb 2017 06:44:29 GMT

Hi Kiran,

Try this

Regards,

Joshua.

ajsjoshua — Fri, 24 Feb 2017 08:10:48 GMT

Hi,

PFA

kiranpatil123 — Tue, 28 Feb 2017 06:14:35 GMT

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