topic Re: Link table in QlikView

Link table

Mon, 18 Jan 2016 12:04:04 GMT

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

Re: Link table

Anonymous — Mon, 18 Jan 2016 12:13:21 GMT

may be like this?

=Count( distinct

If(

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

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

=Count( distinct

If(

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

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

Re: Link table

Mon, 18 Jan 2016 12:19:42 GMT

Hi Balraj Ahlawat,

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

Re: Link table

Anonymous — Mon, 18 Jan 2016 12:30:19 GMT

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

If possible, share a sample app?

Re: Link table

Anonymous — Mon, 18 Jan 2016 12:33:19 GMT

Check these as well, might be helpful for you?

Comparing 2 date fields set analysis

Comparing date field with variable

QlikView Date fields

Re: Link table

cn_sa_dev — Mon, 18 Jan 2016 13:50:13 GMT

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/

Re: Link table

HirisH_V7 — Mon, 18 Jan 2016 13:53:51 GMT

Hi ,

If possible post some sample data,

-Hirish

Re: Link table

jonathandienst — Mon, 18 Jan 2016 13:57:15 GMT

Or have a look at this blog posting from HC:

Canonical Date

Re: Link table

HirisH_V7 — Mon, 18 Jan 2016 14:11:23 GMT

Check this,

Linking to two or more dates