topic Calculated Dimensions and Set Expressions - Bar Chart in QlikView

Calculated Dimensions and Set Expressions - Bar Chart

Wed, 23 Nov 2011 14:32:23 GMT

Hello,

I'm trying to obtain the following result:

In a bar chart I want to see the last 3 months of a selected month (from a list box) and the next 5 weeks. I already tried with calculated dimensions and set expressions without success.

Does anyone already made something similar or can give me a tip?

Best regards,

Re: Calculated Dimensions and Set Expressions - Bar Chart

swuehl — Wed, 23 Nov 2011 19:04:19 GMT

Maybe like attached?

I used a data island for month to select from (MonthSelect) and then a calculated dimension like:

=if(Month< MonthSelect and Month >= addmonths(MonthSelect,-3),

Date(Month,'YYYY-MMM'),

if(Week >= MonthSelect and Week <= MonthSelect+5*7, Week)

)

Hope this helps,

Stefan