topic Re: Barchart in QlikView

Barchart

Zaga_69 — Sat, 16 Nov 2024 03:55:53 GMT

Hi guys,

I would like to build a barchart by year, but for the current year I just need the current month: For example:

When the end-user selecting a year and month in the dashboard the barchart should ignore the year and month selected for the previous years, however it should show the measure for the current month a and current year.

The measure I created to ignore the selections in the dashboard:

SUM({<Year, Period>}SALES)

any idea?

Many thanks

Re: Barchart

Vegar — Fri, 05 Apr 2019 20:10:07 GMT

I see two approaches
1. Create a new field that is mixing the value of current month with previous years. Use that field as a dimension for you chart. Maybe an "As of calendar"
2. Create multiple expressions in you chart and use hide conditions to hide the years that you don't want to see.

Re: Barchart

Zaga_69 — Fri, 05 Apr 2019 20:25:36 GMT

Hi Vegar,

I created two measures:

CURRENT PERIOD

sum({< Year_Month={"$(=max(Year_Month))"}>}Sales_New_Products)

PREVIOUS YEARS

sum({< Year={"<=$(=max(Year))"}>}Sales_New_Products)

When selecting the current year (2019) and any period it works well,however when selecting a lower period than the current year, of course all the years won'be shown.

The chart below contains two measures and in the Presentation option I selected the Stacked bar option.

Any idea how it could work? Your help will be appreciated.

Re: Barchart

Vegar — Fri, 05 Apr 2019 20:32:19 GMT

Won't you get in trouble with
PREVIOUS YEARS

sum({< Year={"<=$(=max(Year))"}>}Sales_New_Products)

It includes the max year, should it not be
PREVIOUS YEARS

sum({< Year={"<$(=max(Year))"}>}Sales_New_Products)

Re: Barchart

Zaga_69 — Fri, 05 Apr 2019 20:41:31 GMT

It was a misspelling from my side.

However, still I have the issue that the bar chart will react to the Year and Period selected by the user in the dashboard

Re: Barchart

Vegar — Sat, 06 Apr 2019 03:31:11 GMT

Ny period you mean the field Year_Month? The selection of that field will impact your years so you need to cancel it in the Set.

sum({< Year_Month, Year={"<$(=max(Year))"}>}Sales_New_Products)