Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a weekend date as my filter option. As we follow different calendar so we have a different weekend dates.
Weekend date is the filter option.
I am calculating week on week where current week value is sum(sales)
the previous week formula that i have written is
SUM({<WEEKEND_DATE = {'$(=MAX(WEEKEND_DATE-7))'}>} sales)
but after many try and attempts of doing this i am getting the value as 0 always. Please suggest.
Note : Weekend date is difference of 7 days
Hi,
Try this,
using your max(Date) and modify your'e date format,
Sum({$<Date={">=$(=Date(WeekStart(Max(Date),-1, 0),'DD-MM-YYYY'))<=$(=Date(WeekEnd(Max(Date),-1, 0),'DD-MM-YYYY'))"}>}Sales)
HTH,
Hirish
SUM({<WEEKEND_DATE = {"$(=DATE(MAX(WEEKEND_DATE-7),'YourDateFormatforWeekendDate')"}>} sales)
Hi Vineeth,
No Luck
Its still Null.
Hi Hirish,
I already have week start date with me.. Just want to know the previous week value.
Hi,
Check this
Sum({$<WEEKEND_DATE={"$(=Weekend(Max(WEEKEND_DATE),-1))"}>}sales)
If it doesn't work means, There may be no data for the previous week or some date format issue may persist with it.
Else,please post some sample data.For further assistance.
HTH,
-Hirish
Hi,
Do like this i think you will get.
First create on variable like
vTT=date(date(max(DT1),'DD/MM/YYYY')-7,'DD/MM/YYYY') --> variable overview
after write below expr
=sum({<DT1={"$(vTT)"}>}Marks)
Hi Lakshmipathi,
Its still the same. Its displaying as 0. some where i feel that there is a problem with the date that we are using.
Hi,
It is working my side. Post your wkdate field values format.
my weekend date format in the oracle table is like "07-JAN-16"
When I am using that in Qlik sense - Filter Pane, I am converting that into
DATE((WEEKEND_DATE),'DD-MM-YYYY')
Now in the filter pane, I can see the values as " 15-12-2016"