Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Link table

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

8 Replies
Anonymous
Not applicable
Author

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))


Not applicable
Author

Hi Balraj Ahlawat,

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

Anonymous
Not applicable
Author

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

If possible, share a sample app?

Anonymous
Not applicable
Author

cn_sa_dev
Partner - Contributor III
Partner - Contributor III

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
Master
Master

Hi ,

If possible post some sample data,

-Hirish

HirisH
“Aspire to Inspire before we Expire!”
jonathandienst
Partner - Champion III
Partner - Champion III

Or have a look at this blog posting from HC:

Canonical Date

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
HirisH_V7
Master
Master

Check this,

Linking to two or more dates

HirisH
“Aspire to Inspire before we Expire!”