Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
satyagopu
Contributor II
Contributor II

Line Trend chart loosing color when date is selected

When we give 2 dimensions (Date and other) and 1 measure in Line Trend Chart, getting the issue like loosing the colors after selecting  the date from filter pane. even after ignoring the date in set analysis

Line Chart dimensions and Measures are given below

Dimension 1 : MyDate

Dimension 2 : Country

Measure : Sum({<MyDate=, MyDate = {">=$(=AddMonths(Date(Max(MyDate)), -11))<=$(=Date(Max(MyDate)))"}>}MeasureValue)

Color setting : Auto

1 Reply
dwforest
Specialist II
Specialist II

Typically this would be because the data is not associated with a valid date.

The set analysis does not ignore MyDate, It does nothing to set MyDate=, then MyDate={some set expression}. The set expression is absolute (unless -= is used).

Would need sample data to help further,