Link table

[#1]

Hi All ,

I am trying to get a link table with 3 date fields and then I want to map this link table with master calendar, master calendar should has Week end and week start dates.

to achieve this I  have concatenated the three date fields as a single date and then I have mapped it with master calendar, in the master calendar I have calculated week end and week start date.

now I would like to use this week end date  in a straight table as dimension and the expression count of Item id  when Invoice Date is <= week ending date and the Sale Date > the week ending date or the Accounting Period Sale = 0.

I tried it but I am not getting correct results , can any one help on this how to get the Count of Item id. for every weekend  according to the above condition.

Regards

John

[Anonymous]

may be like this?

=Count( distinct

If(

([Invoice Date] <= [Week Ending Date] and SalesDate > [Week Ending Date])

or [Accounting Period Sale]=0, ItemId))

or

=Count( distinct

If(

([Week Ending Date] >= [Invoice Date] and [Week Ending Date] < SalesDate)

or [Accounting Period Sale]=0, ItemId))

[#3]

Hi Balraj Ahlawat,

thanks for your prompt response, I tried it but no luck,

[Anonymous]

Make sure, Format of all the date fields should be common

If possible, share a sample app?

[Anonymous]

Check these as well, might be helpful for you?

Comparing 2 date fields set analysis

Comparing date field with variable

QlikView Date fields

[cn_sa_dev]

There's a great tutorial by Rob Wunderlich on the Qlikview Cookbook blog regarding common calendars and comparisons between them.

http://qlikviewcookbook.com/download/tutorial-using-common-date-dimensions/

[HirisH_V7]

Hi ,

If possible post some sample data,

-Hirish

[jonathandienst]

Or have a look at this blog posting from HC:

Canonical Date

[HirisH_V7]

Check this,

Linking to two or more dates