Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
Hi Balraj Ahlawat,
thanks for your prompt response, I tried it but no luck,
Make sure, Format of all the date fields should be common
If possible, share a sample app?
Check these as well, might be helpful for you?
Comparing 2 date fields set analysis
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/
Hi ,
If possible post some sample data,
-Hirish
Or have a look at this blog posting from HC: