Chart Background Color depending on date

Thu, 05 Sep 2013 08:56:30 GMT

Hi all

I have a bar chart that give me data for the last 10 days (last day on the right). Last 10 days are selected thanks to set analysis (OK, it works)

I would like to have all the days pertaining to the same week as the last day to be in orange, values for other days in grey.

It works, no problem

The only problem is that when I add the condition on the bar colors, my set analysis on 10 days is not taken in account and Qlikview displays a lot of days, not only the last 10 (see images below)

Any idea on why I have this behavior?

Thanks in advance

Hub

Without colors : 10 days thanks to set analysis

With Colors : lots of days but the last days are in orange because they belong to the same week

Formula used in Graph Properties > Expression > Background Color > Definition :

= if(Week(PeriodDate.Date)=Week($(vReportDate)), cOrangeStandard, cVeryLightGrey)

PeriodDate.Date is the date on the Y axis...

Re: Chart Background Color depending on date

swuehl — Thu, 05 Sep 2013 09:01:13 GMT

Try

= if( only ({<YourSetExpressionToLimitTheWeeks>} Week(PeriodDate.Date))=Week($(vReportDate)), cOrangeStandard, cVeryLightGrey)

Re: Chart Background Color depending on date

Thu, 05 Sep 2013 12:09:40 GMT

Thanks swuehl!

First time I use the ONLY aggregation function, it took me some tries but finally got there thanks to your hint 🙂

topic Re: Chart Background Color depending on date in QlikView

Chart Background Color depending on date

Re: Chart Background Color depending on date

Re: Chart Background Color depending on date