Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can someone help me please.
i am trying to generate a graph in qlilview that shows the last 14 days with of data on a daily basis (ie there will be 1 bar for each day for the last 14 days)
please could someone help me the the correct set analysis expression to write
Try
Sum({<Date={">=$(=Date(Max(Date)-14))<=$(=Date(Max(Date)))"}>} Sales )
Something like this. Assuming you are trying to calculate Sum(Amount) over the 14 days and that your Date field is DateField.
sum(aggr(rangesum(above(total sum({<MonthField=,YearField=,DateField=>} Amount),0,14)),DateField))
Hi Darren,
Please mention the field names too. That would help us give you correct answer. I found below expression, this shows 14 days sales in bar chart.
=sum({$<SALESDATE={"=SALESDATE>=Max(total Floor(SALESDATE))-14"}>}SALES)
Refer: https://community.qlik.com/t5/New-to-QlikView/Show-last-15-days-sales-in-a-bar-chart/m-p/585836
cheers,
-Basav
Hi Darren, how are you?
What is the dimension in the bar chart you have given?
Can you put the full Name in the dimension and the Expression as
=sum({$<YourDateField={"=YourDateField>=Max(total Floor(YourDateField))-14"}>}SALES)
Does this making sense to you?
Regards,
-Basav
Try
=Sum({$<[Full Name]={'Darren Keirl','Chris Phillips','Gemma Young','Micheal
Heaney','Ginnie Brunning','Terry Crampton','Lisa Lewer','Emma
Hares','Julita Wakefield','Liz Halliwell','Sandra Searle'},
CalenderDay ={">=$(=CalenderDay(Max(Date)-14))<=$(=CalenderDay(Max(Date)))"} >}
[TotalExternalInboundAnswered]+[TotalExternalInboundAnswered])