Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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
balrajahlawat
Champion
Champion

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,

balrajahlawat
Champion
Champion

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

If possible, share a sample app?

balrajahlawat
Champion
Champion

cn_sa_dev
Partner
Partner

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
Partner

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!”