Bar Chart Date range

[shanes]

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'))

[Kashyap_R]

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

[shanes]

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?

[shanes]

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)