topic Ignore Month selection for Dimension - Combo Chart in QlikView

Ignore Month selection for Dimension - Combo Chart

Sat, 05 Dec 2015 02:29:11 GMT

I have a requirement to show a combo chart with Months as a dimension and sales and budget as measure. When the user selects any month of the year, the chart should still show all the months but data only upto selected month.

Eg: If user selects March, then combo chart should have bars for Jan,Feb and March and show 0 values for the months from Apr to Dec. Then months should not be suppressed

Re: Ignore Month selection for Dimension - Combo Chart

swuehl — Sat, 05 Dec 2015 13:41:22 GMT

Something like

=Sum({<MonthField = {"<=$(=Max(MonthField))"}>} SalesField) +sum({1} 0)

resp.

=Sum({<MonthField = {"<=$(=Max(MonthField))"}>} BudgetField) +sum({1} 0)

On presentation tab, disable 'suppress zero values'

Re: Ignore Month selection for Dimension - Combo Chart

mikkeltaylor — Sat, 05 Dec 2015 13:41:48 GMT

Hi,

I don't know if there is a solution within the chart, but hic‌ posted a good blog post here ‌that uses an "as-of" table in the script, which should accomplish what you are looking for.

Regards

Mike.