Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I currently have a sheet which shows incoming volumes
I was wondering how I would have the bar chart default to show the last 7 days of data rather than every entry.
The dimension expression: is =if(Len(New_Date)>0,Date(New_Date,'DD-MM-YYYY'))
Hi
try this if you want in dimension
if(New_Date>='$(=Date(max(New_Date)-6))' and New_Date<='$(=Date(max(New_Date)))',New_Date)
In measure
Sum({<New_Date={">=$(=Date(max(New_Date)-6))<=$(=Date(max(New_Date)))"}>}Value)
Hope this helps
Thanks
Amazing! i think it worked! Is this a rolling 7 days?
Also, I have another chart which i believe is linked which just shows the total of the related graph but now that I have changed the bar chart the numbers don't align.
My Bar graph shows volumes from 7 days where as my total chart shows numbers from all dates that are loaded into Qlik.
The dimension in this is:=Count({<Flag={'AO'}>}Alert_C)
Are you able to help so the expression aligns to the chart?
Thanks so much with the dimension expression.
I have a KPI Chart above that counts the total of alerts - =Count({<Flag={'AO'}>}Alert_C)
How would i change this expression so it matches the bar chart with the current expression?
if(New_Date>='$(=Date(max(New_Date)-6))' and New_Date<='$(=Date(max(New_Date)))',New_Date)