Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Zaga_69
Creator
Creator

Barchart

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.

HEN barchart.JPG

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

SUM({<Year, Period>}SALES)

 

any idea?

 

Many thanks

Labels (1)
5 Replies
Vegar
MVP
MVP

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.
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Zaga_69
Creator
Creator
Author

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.

HEN barchart v2.JPG

Vegar
MVP
MVP

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)
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Zaga_69
Creator
Creator
Author

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

Vegar
MVP
MVP

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)


Plees ekskuse my Swenglish and or Norweglish spelling misstakes